topic Gauge Settings Not Working As Expected in QlikView

Gauge Settings Not Working As Expected

Tue, 01 Mar 2011 02:43:41 GMT

I am having trouble getting my min and max setting to correctly set themselves up in my gauge. I am using the following:

Dimension: CalendarDate

Expression: interval(avg({<QUALIFY_AVG_OUTPAT_WAIT_YN = {'Y'}, QUALIFY_MRI_CYCLE_YN = {'Y'}, SEDATION_YN = {'Y'}>}PROC_BEGIN_TIME-APPT_TIME),'mm')

Presentation Tab Looks Like the following:

Segment 1 Setting

Segment 2 Setting

The Guage Returned Looks like the following:

The pop-up text on the needle gauge show "21" which is the correct number. However, my min gauge setting should show 1 and my max should be 48.

0-20 should be green while anything over 20 should be Red.

Any suggestions?

Thanks,

Scott

Gauge Settings Not Working As Expected

vupen — Tue, 01 Mar 2011 07:30:51 GMT

The expression should be an aggregate function..

Switch the AVG and Interval functions:

avg(interval({<QUALIFY_AVG_OUTPAT_WAIT_YN = {'Y'}, QUALIFY_MRI_CYCLE_YN = {'Y'}, SEDATION_YN = {'Y'}>}PROC_BEGIN_TIME-APPT_TIME),'mm'))

Gauge Settings Not Working As Expected

jonathandienst — Tue, 01 Mar 2011 09:29:09 GMT

Scott

I think your problem is caused by the dual value that interval returns. The text representation (what you are seeing on the popup and as displayed on the chart tic lables) is in minutes. The internal value is actually in day fraction terms - ie a text value of '21' has an internal numerical value of 21 / (24 * 60) = 0.0145833.. You can verify this by putting your expression inside a Num() function in a text box.

So what this means is that your max value is in the numeric representation and is 48 days, not 48 minutes, Segment 1's lower bound is 1 day (should be zero). Segment 2's lower bound is 20 days. That explains why the tic lables on the guage are strange (they are the text representation,

Try changing:

max value to =48/(24*60)
segment 1 lower bound to 0
segment 2 lower bound to =20/(24*60)

I don't think that it is necessary to change your expression.

Hope that helps.

Jonathan

Gauge Settings Not Working As Expected

Tue, 01 Mar 2011 13:45:56 GMT

Thanks Jonathan!!

Works Great!!

Gauge Settings Not Working As Expected

jonathandienst — Tue, 01 Mar 2011 15:42:54 GMT

Scott

Could I suggest that you verify the correct answer, rather than your response. The purpose is to direct people with the same problem to the solution to the problem, without having to read all the postings.

Thanks

Jonathan

Gauge Settings Not Working As Expected

Tue, 01 Mar 2011 16:18:24 GMT

Sorry about that.. hit the button in the wrong spot. Got if verified... Thanks!!