Syntax issue

[samvile18]

Hi all,

I have the following set analysis which works really well, the problem I'm having though is the data in the graph still changes if someone selects a month from my list box.

I want this table to always show YTD 2012 data no matter what selection is made by the user.

=Sum({$<ExtractDate={">=$(vStartDate)<=$(vEndDate)"},Measure={'APE AP'}>} Value)/1000

vStartDate = 01/01/2012

vEndDate = 31/12/2012

Am I missing something simple?

[jagan · Accepted solution]

Hi,

Exclude your date filters selection like Year, Month, Quarter, Week.

=Sum({$<Year=, Month=, Quarter=, Week=, ExtractDate={">=$(vStartDate)<=$(vEndDate)"},Measure={'APE AP'}>} Value)/1000

This way you can ignore the selections using Set analysis.

Regards,

Jagan.

[forte]

Hi Sam ,

If you want to avoid selections on some fields just change your Set analisys as follows :

=Sum({$<ExtractDate={">=$(vStartDate)<=$(vEndDate)"},Measure={'APE AP'} , Month = >} Value)/1000

I have supposed that fiel's name is Month. You can do these with every field you want to avoid Qlik standar functionality,

Hope it helps

Regards

[samvile18]

Brilliant, thanks for your help.