Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

multiple expressions in Sum Function

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

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

try this

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

View solution in original post

2 Replies
alexandros17
Partner - Champion III
Partner - Champion III

try this

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

Not applicable
Author

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