topic Re: multiple expressions in Sum Function in QlikView

multiple expressions in Sum Function

Fri, 19 Apr 2013 14:51:46 GMT

hi all,

i am trying to sum my value based on 2 columns : 1 is currency and 2 is date

So my raw data has 3 columns Date, Currency and Value and if i make a straight table for 1 dedicated currency

i select dimension as Date and Currency and in expression i have SUM({$<Currency={EUR}>}[Value]) and i gives correct data, but i need to include Date = today() also in sum expression.

is it possible?

thanks

Re: multiple expressions in Sum Function

alexandros17 — Fri, 19 Apr 2013 14:59:26 GMT

try this

SUM({$<Currency={EUR}, Date={'$(=Today())'}>}[Value])

Re: multiple expressions in Sum Function

Fri, 19 Apr 2013 15:27:27 GMT

same way if i want to put 3 expressions, i follow the same?