topic Re: Sum Calculation in QlikView

Sum Calculation

Mon, 03 Nov 2014 18:05:36 GMT

Hi Friends

i have a table which contains Name & Value like :

Now i need to calculate the sum of value whose name should start with "ALL" and the Name must contain *** or ###.

Thanks in Advance

Regards

Roopesh

Mon, 03 Nov 2014 18:17:14 GMT

sum(if(NAME like 'ALL*' and NAME like '*****' or NAME like '*###*', VALUE))

JonnyPoole — Mon, 03 Nov 2014 18:18:21 GMT

Attached has samples from load script, chart (calc dimension) and text box

its_anandrjs — Mon, 03 Nov 2014 18:36:55 GMT

Hi,

You can try this way also in the load script by adding two flags one for * and other for # symbols and load table and do sum in the front end.

Table1:

LOAD NAME,VALUE,if(Index(NAME,'***') = 0,0,1) as IndexString, if(WildMatch(NAME,'*###*'),1,0) as WildString;

LOAD * Inline

[

NAME, VALUE

ALL_123_ABC_***_567, 10

ALL_1234_***_ABC_568, 20

ALL_1234_###_569, 30

ALL_1234_570, 40

ALL_1234_CD_###_571, 50

ABC_1234_***_572, 60

];

Final:

LOAD

NAME,VALUE as Value

Resident Table1

Where (Left(NAME,3) = 'ALL' and IndexString = 1) or WildString = 1;

DROP Table Table1;

Regards

Anand