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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

creation of an indicator with conditions

Hello,

I am trying to create an indicator in Qlik

if my "dif date" is Superior to 90 days , i want to sum those value and divided by the total .

If the result is Superior to 4% led red if inferior led green

my unworking formula :

= if((Diff_Date > 90 , sum(([Value]) / ( Value)) < 0.04),'qmem://<bundled>/BuiltIn/led_g.png','qmem://<bundled>/BuiltIn/led_r.png')

Thank you  for your help !

10 Replies
Not applicable
Author

Hey Tamil,

It is working

Thank you very much