Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Flag creation help


Can any one please help me on below flag creation

When Rate is greater than Threshold then its Pass else its Fail.

I have tried like below f([Pass Rate]>[Red %],'Pass','Fail') but getting all 'Fail' records under Flag.

Please help me on this.



Thanks in advance

2 Replies
Partner - Creator III
Partner - Creator III

Try converting the Threshold into % format and try your if statement
Partner - Creator III
Partner - Creator III

Convert both pass rate and Red Values into same data format like if you are considering [Red % ]value in % so make sure Pass Rate should be %.