Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Samrithi
Contributor III
Contributor III

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.

0 Replies