Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Partner
Partner

Functions within Set Analysis

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,

M.

Tags (1)
1 Solution

Accepted Solutions

Re: Functions within Set Analysis

try this and let me know


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

3 Replies

Re: Functions within Set Analysis

try this and let me know


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

Partner
Partner

Re: Functions within Set Analysis

Brilliant!

I had missed the quotes around the dollar expansion.

Many thanks!

M.

geetaalhan
Contributor

Re: Functions within Set Analysis

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