creation of an indicator with conditions

[#1]

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 !

[tamilarasu]

Hi Margaux,

Try,

= If(Diff_Date > 90 , If( ( Sum(Value) / Sum(Total Value) ) < 0.04, 'qmem://<bundled>/BuiltIn/led_g.png','qmem://<bundled>/BuiltIn/led_r.png'))

If this is not working, please share your file (or provide sample file)

[vikasmahajan]

PFA

Vikas

[#4]

Hi Tamil,

Thank you for your time

It is still not working i cannot see the led "green or red" on my pivot table.

Do you have an other idea that i can try ?

Thanks

Margaux

[#5]

Hi Vikas,

I didn't know that we can have a gauge

Still i have a problem with my first condition :

The measurement is Open work with aging > 90 days amount / total amount open work orders.

If the result is above 5%, it is a warning status.

exemple

Aging Range	Amount
i<1month	26,3
1<i<3months	3,0
3<i<6months	0,9
6<i<12months	0,2
i>12months	0,0
Grand total	30,4
Open work orders > 3 months amount	1,1
Measurement	4%

Thank you,

[vikasmahajan]

Pl;ease attach your qvw

[tamilarasu]

Create a new expression like below and see what are all the values you are getting.

= If(Diff_Date > 90 , Sum(Value) / Sum(Total Value) )

[#8]

Here the QV example

[#9]

Hey Tamil,

i created a new expression with the formula and the result is empty

[tamilarasu · Accepted solution]

Hi Margaux,

You will see empty cells because you have not not mentioned else part in the "If" condition ( If Diff_Date is less than 90.???).

I have changed the expression representation from "Traffic light Gauge" to "Image".

Since you have not mentioned how to show the Diff_Date values that are less than 90 days, you will not see any indicators.

You can understand the problem by checking the attached file. How you wish to see the chart.? Could you elaborate further.?