topic Re: Help with Set Analysis in QlikView

Help with Set Analysis

ramanarayan — Sat, 16 Nov 2024 05:00:43 GMT

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)

agigliotti — Mon, 10 Dec 2018 10:33:33 GMT

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

ramanarayan — Mon, 10 Dec 2018 11:39:14 GMT

Hi,

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

agigliotti — Mon, 10 Dec 2018 11:50:57 GMT

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

marcus_malinow — Mon, 10 Dec 2018 11:55:16 GMT

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