Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
martynlloyd
Partner - Creator III
Partner - Creator III

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.

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

try this and let me know


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

View solution in original post

3 Replies
alexandros17
Partner - Champion III
Partner - Champion III

try this and let me know


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

martynlloyd
Partner - Creator III
Partner - Creator III
Author

Brilliant!

I had missed the quotes around the dollar expansion.

Many thanks!

M.

Anonymous
Not applicable

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