topic Re: Expression: sum in QlikView

Expression: sum

Thu, 25 Apr 2013 02:10:40 GMT

HI All,

Im having difficulties on the expression syntax. I have 1 table for example:

TABLE_A

Fields are : AA, AB, AC, AD, AE

how do i get the total of AA ...when AA is ....when AB=Z and when AB=M

(sum of Z) - (sum of M)

this is how i did it..but there is syntax error. kindly help.

(sum (AB={Z}> } AA) - sum (AB={M}>} AA))

thank you

Re: Expression: sum

Thu, 25 Apr 2013 02:42:01 GMT

the scenario is just the same like this:

(sum( {$<Year={$(=Max(Year))}, Month = {"<=$(=Max(Month))"}, Plant = {'0001', '0002', '0003', '0004'}, Type = {111}>} Qty)

-sum( {$<Year={$(=Max(Year))}, Month = {"<=$(=Max(Month))"}, Plant = {'0001', '0002', '0003', '0004'}, Type = {112}>} Qty))

Re: Expression: sum

sujeetsingh — Thu, 25 Apr 2013 03:11:24 GMT

First explain what is this Z....M..???

Re: Expression: sum

Thu, 25 Apr 2013 04:13:05 GMT

Did got your exact requriment, but try this

Sum({<AB={Z}>}AA) - Sum{<AB={M}>AA}

Regards,

Amay