topic Re: Functions within Set Analysis in QlikView

Functions within Set Analysis

martynlloyd — Mon, 27 Oct 2014 11:36:59 GMT

In a chart expression I select the quarter to which the SELECTED month belongs:

=QuarterName(MakeDate(KPIYear,KPIMonth))

Will give me the quarter name in a column - I now need to calcuate the amount -

sum({$<KPIMonth=, Quarter={'Jul-Sep 2014'} >} TRPActual)

Works OK, but I need the 'Jul-Sep 2014' to be dynamic, based on the selected year and month (KPI...).

What is the correct syntax for the set analysis statement?

Many thanks,

alexandros17 — Mon, 27 Oct 2014 11:41:31 GMT

try this and let me know

sum({$<KPIMonth=, Quarter={'$(=QuarterName(MakeDate(KPIYear,KPIMonth)))'} >} TRPActual)

martynlloyd — Mon, 27 Oct 2014 11:44:44 GMT

Brilliant!

I had missed the quotes around the dollar expansion.

Many thanks!

Anonymous — Mon, 27 Oct 2014 12:00:44 GMT

Hi,

You can make a variable like

v_quarter=QuarterName(MakeDate(KPIYear,KPIMonth))

and use that variable in set analysis which is as follows :

sum({<$(v_quarter)={"*"}>}TRPActual)

Hope it helps.

Thanks,

Geeta