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

Variables and Flags

Hello,

I want to exclude some types of my calculated measure.

So I need to define a flag. My approach was to define a variable in the UI.

vFlag: if( TYPE='A', 1,0)

Then I created a master element Using this Formula (and lots of variations):

mRevenue:

Sum(If(($(vFlag),REVENUE,0)))


Sum(If(($(vFlag)=1,REVENUE,0)))

There is no syntax error. No results.

What's wrong here ?

And what are your experiences with the handling of measures in the UI ?

Thanks in advance!

0 Replies