Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
ramanarayan
Creator
Creator

Help with Set Analysis

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)

Labels (1)
4 Replies
agigliotti
Partner - Champion
Partner - Champion

let's try this:
=sum( {<Mon = {"$(=Max(mon))"}>} Amt )
I hope it helps.
ramanarayan
Creator
Creator
Author

Hi,

 

I tried using this expression but the output is 0 and not 7. Attached is the qvw file

agigliotti
Partner - Champion
Partner - Champion

try this:
sum( {< Mon = {"=Month(Mon) =month(date(max( total Mon)))"}>} Amt)
marcus_malinow
Partner - Specialist III
Partner - Specialist III

sum({$<Mon={'$(=Date(max(Mon)))'}>}Amt)