Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to calculate the sum of Amt using a set analysis expression but not been successful
I need qlikview to give me the total sales amount for the max of month.
In my attached qv file, the max month is Sept and the amount is 7. I am using the following expression but it does not seem to work.
=sum({<Mon = {"max (mon)"}>}Amt)
Hi,
I tried using this expression but the output is 0 and not 7. Attached is the qvw file
sum({$<Mon={'$(=Date(max(Mon)))'}>}Amt)