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

Set Analysis Qlikview If statement

Hi all,

how can i put this expression into my expression of the graph within the set analysis:

 

if ( Today(1)-365<=Num(DATE)

 

I try to write like this but it gives error:

 

Sum( {< if ( Today(1)-365<=Num(DATE)}>} (Quantity1 + Quantity2))

 

Thanks.

Labels (6)
1 Solution

Accepted Solutions
marcus_sommer

You may try it in this way: Sum( {< DATE = {"<=$(=Today(1)-365)"}>} (Quantity1 + Quantity2))

View solution in original post

1 Reply
marcus_sommer

You may try it in this way: Sum( {< DATE = {"<=$(=Today(1)-365)"}>} (Quantity1 + Quantity2))