Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
Hey Tamil,
It is working
Thank you very much