Skip to main content
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

QlikSense upgrade- set expression not working properly

We have done upgrade from Qlik Sense 3.1 SR4 to Qlik Sense November 2017 Patch 2 -11.24.4.

In one of the chart, I am showing Rolling last 13 months trending using set expression

sum({<[AsOfDate.Month]=,[AsOfDate.MonthIndex]={">= $(=$(vMaxMonthIndex)-12) <=$(=$(vMaxMonthIndex))"},[Active Flag] ={"A"}> } Exposure )

This was working fine before upgrade.

This expression is not working properly after upgrade. Do I need to change anything in this expression?



4 Replies

Try with single quote here like 'A', may be-

[Active Flag] ={"A"}> }

Contributor II
Contributor II


This is not working. I tried but output is still same.


try as follow: I'll just eliminate the space btwn >= and $(=$(vMaxMonthIndex)-12)

It should work:

sum({<[AsOfDate.Month]=,[AsOfDate.MonthIndex]={">=$(=$(vMaxMonthIndex)-12) <=$(=$(vMaxMonthIndex))"},[Active Flag] ={"A"}> } Exposure )

if not, try:

sum({<[AsOfDate.Month]=,[AsOfDate.MonthIndex]={">=$(vMaxMonthIndex)-12) <=$(vMaxMonthIndex))"},[Active Flag] ={"A"}> } Exposure )

else, try to put the inside of ur variables directly wihin the set expressions and see what happens.

sometimes, when a variable is defined with a '=' It won't work in a set expression (and vis versa)

Contributor II
Contributor II

Thank you Omar,

I tried all three options you suggested, but nothing is working.

for the second option you suggested, it's not giving me the rolling last 12 months from the selected as of date month.

One more thing to note here-

When I load my expression, first time it gives me all the available months trending.

But when I select the as of date month filter, it gives me rolling last 12 months with required values but all lines are greyed out(not showing colors) as