Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
ramanarayan
Contributor

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)

Tags (1)
Labels (1)
4 Replies
Highlighted
Partner
Partner

Re: Help with Set Analysis

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

Re: Help with Set Analysis

Hi,

 

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

Partner
Partner

Re: Help with Set Analysis

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

Re: Help with Set Analysis

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