Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: creation of an indicator with conditions

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

10 Replies

Re: creation of an indicator with conditions

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
Esteemed Contributor

Re: creation of an indicator with conditions

PFA

Vikas

Not applicable

Re: creation of an indicator with conditions

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

Re: creation of an indicator with conditions

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
Esteemed Contributor

Re: creation of an indicator with conditions

Pl;ease attach your qvw

Re: creation of an indicator with conditions

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

Re: creation of an indicator with conditions

Here the QV example

Not applicable

Re: creation of an indicator with conditions

Hey Tamil,

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

Re: creation of an indicator with conditions

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

Community Browser