Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis with variables problem

Hi all,

I've got a set analysis statement. If I put 1 variable in it, it works fine, but as soon as I put in 2 variables its does not calculate any more.

This is the statement:

Sum ({$<Month= {">=Last12Month<=maxMonth"}>}Sales)

It should calculate everything between Last12Month and maxMonth.

Can somebody help me?

Tnx in advance

rey-man



1 Solution

Accepted Solutions
danielrozental
Master II
Master II

I think your expression should be like this for variables to be correctly interpreted

Sum ({$<Month= {">=$(Last12Month)<=$(maxMonth)"}>}Sales)

View solution in original post

1 Reply
danielrozental
Master II
Master II

I think your expression should be like this for variables to be correctly interpreted

Sum ({$<Month= {">=$(Last12Month)<=$(maxMonth)"}>}Sales)