Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.
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
Brilliant, thanks for your help.