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.

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

Flag creation help

Hi,

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.

Threshold.png

 

Thanks in advance

2 Replies
Uday_Pasupuleti
Partner - Creator III
Partner - Creator III

Try converting the Threshold into % format and try your if statement
raman_rastogi
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 %.