topic Re: Syntax issue in QlikView

Syntax issue

samvile18 — Wed, 12 Dec 2012 10:59:57 GMT

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?

Re: Syntax issue

jagan — Wed, 12 Dec 2012 11:11:22 GMT

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.

Re: Syntax issue

forte — Wed, 12 Dec 2012 11:13:33 GMT

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

Re: Syntax issue

samvile18 — Wed, 12 Dec 2012 11:15:03 GMT

Brilliant, thanks for your help.