topic Set analysis help in QlikView

Set analysis help

sundarakumar — Mon, 26 May 2014 07:13:51 GMT

Hi All,

I have data quarter wise, now I want to display the last quarter's values.

my dimension is year. so when I use {<quarter=$(max(=(quarter))>} an not getting any value for 2014 since there is no q4 data for 2014. I have only q1 data for 2014. so I want the chart to show q4 data for all years other than 2014 and q1 data for 2014,. my requirement is always show the max quarter data at any time. Please help me with the set analysis expression for this scenario.

I know this can be done with

if(year=max(year),

if quarter=4 set analysis to Q4 and 3 2 1 so on only for max year

and rest with set analysis max quarter. But I think this can be done in set analysis itself.

Thanks in advance

-Sundar

Re: Set analysis help

vikasmahajan — Mon, 26 May 2014 07:22:03 GMT

Hii,

Find attachment of master calendar Please link it with your transaction data and

give following expression

SUM({$<FiscalYear={$(=max(FiscalYear))}>} [ Sales Amount])

Hope this help you.

Vikas

Re: Set analysis help

jagan — Mon, 26 May 2014 07:48:47 GMT

Hi,

Try like this

=Sum(Aggr(If(Quarter = Max(TOTAL <Year> Quarter), Sum(Sales), 0), Year, Quarter))

Sum(Aggr(Sum({<quarter= {'$(=max(quarter))'}>} , Year))

Hope this helps you.

Regards,

Jagan.