Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Samrithi
New Contributor II

date Variable not working in set analysis

Hi,

We are using Sep 2018 Version 12.5.

I have Expression below using Date range variable in set analysis but its not getting filtered on variable date range.

Its working on my local desk because I am using latest version.

Tried in many different ways but still not working. please suggest.

And if any link for sept 2018 version 12.5 is there online, please send me the link so that I can try installing on local machine and try the same expression.

"(if([BBK.WeekDay]='Thu',
num((rangesum(Before(sum({<[BBK.PERIOD]={">=$(=vMinDate)<=$(=vMaxPeriod)"}>}[BBK.BBK_ITEM]),0,day([BBK.PERIOD])))/
rangesum(Before(sum({<[BBK.PERIOD]={">=$(=vMinDate)<=$(=vMaxPeriod)"}>}[BBK.BBK_OPP_ITEM]),0,day([BBK.PERIOD])))),'#0.00%')".

I used in different ways also below but still not working.

"{">=$(=$(vMinDate))<=$(=$(vMaxPeriod))"} or {">=$(=date($(vMinDate))<=$(=date(vMaxPeriod))"}"

Appreciate the solution or the link to download sep 2018 version 12.5 version.

Thanks.