topic Re: Period Comparison in Water Cooler

Period Comparison

zwyne — Fri, 14 Dec 2018 23:06:15 GMT

Hi there,

I have defined my period comparison as follows:

vSetMTD : Year={'$(vMaxYear)'},Month={'$(vMaxMonth)'},Day='<=$(vMaxDay)'},Date=,MonthYear=

vSetPreviousMonth Year={'$(vPriorMonthYear)'},Month={'$(vPriorMonth)'},Day={'<=$(vMaxDay)'},Date=,MonthYear=

When I use it like below it works fine

count({$<Flags={'MajFlag'},Year={'$(vMaxYear)'},Month={'$(vMaxMonth)'},Day={'<=$(vMaxDay)'},Date=,MonthYear=>}Flags)

But when I try to use it like

count({$<Flags={'MajFlag'},$(vSetMTD)>}Flags) it throws an error. Similarly for the vSetPreviousMonth

How can I make this to work so that I have to always write: Year={'$(vPriorMonthYear)'},Month={'$(vPriorMonth)'},Day={'<=$(vMaxDay)'},Date=,MonthYear=

Thanks

Re: Period Comparison

dplr-rn — Sat, 15 Dec 2018 04:26:30 GMT

What do you mean by it throws an error? An error in editor?
if you put set analysis expression in variable e.g. vSetMTD sometimes the expression editor shows error but it works

try making the entire set as 1 variable. you will get a error message in editor but it works
e.g.
count({<$(vSetAnalysis)>}Flags)

Re: Period Comparison

dplr-rn — Sat, 15 Dec 2018 04:28:04 GMT

see below examples from quick googling

https://community.qlik.com/t5/QlikView-App-Development/Piece-of-set-analysis-in-a-variable/td-p/683446

https://community.qlik.com/t5/New-to-QlikView/Variable-in-a-part-of-set-analysis/m-p/932119