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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Expression inside an if condition


Can we use a set analysis expression inside an if condition....???

Thanks in advance

Labels (1)
4 Replies
Agis-Kalogiannis
Employee
Employee

We can but it must be inside an aggregation function:

if(sum({1<Year={2008}>}Sales)>0, 1, 0)

Thanks

Agis

stigchel
Partner - Master
Partner - Master

Agis is right, see also

It’s all Aggregations

Agis-Kalogiannis
Employee
Employee

Kushal_Chawda
MVP
MVP

Yes, we can use it. But it depends of scenario.