Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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

Hi,

 

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

Highlighted
Partner
Partner

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

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