Wednesday, November 26, 2014

Showing Cumulative Data in Qlikview Script



LOAD Name,
     Num,
     numsum(Num,peek('S')) as S
FROM
[C:\Documents and Settings\11050.TCPL\Desktop\Almas\cumulative.xls]
(biff, embedded labels, table is Sheet1$);


output:

Name  
Num
S
ABC   
10   
10
XYZ   
20   
30
DEF   
30   
60
GHI   
40   
100
JKL   
50   
150
MNO   
60   
210
PQR  
70  
280
STU   
80   
360
VWX  
90  
450
POP  
100 
550

(the same can be achieved using full Accumulation option for an expression in a pivot table)


2 comments: