Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
ramanarayan
New Contributor III

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
Partner
Partner

Re: Help with Set Analysis

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

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)