Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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 !

1 Solution

Accepted Solutions
tamilarasu
Champion
Champion

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".

Capture.PNG

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

2.PNG

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

View solution in original post

10 Replies
tamilarasu
Champion
Champion

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Not applicable
Author

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

Not applicable
Author

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 RangeAmount
i<1month26,3
1<i<3months3,0
3<i<6months0,9
6<i<12months0,2
i>12months0,0
Grand total30,4
Open work orders > 3 months amount1,1
Measurement4%

Thank you,

vikasmahajan

Pl;ease attach your qvw

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
tamilarasu
Champion
Champion

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) )

Not applicable
Author

Here the QV example

Not applicable
Author

Hey Tamil,

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

tamilarasu
Champion
Champion

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".

Capture.PNG

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

2.PNG

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