# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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
MVP

## Re: Functions within Set Analysis

try this and let me know

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

3 Replies
MVP

## Re: Functions within Set Analysis

try this and let me know

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

Partner

## Re: Functions within Set Analysis

Brilliant!

I had missed the quotes around the dollar expansion.

Many thanks!

M.

Highlighted
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