topic Re: problems with a gauge chart in QlikView

problems with a gauge chart

Anonymous — Tue, 13 Sep 2011 14:11:54 GMT

Hi Guys,

I have a gauge chart that calculates the performance of shipments ontime. This is the expression that I use:

Count({<Status={OnTime}>} Destination) / Count (Destination)

The results are oke as long as I don't select the late shipments in the one of the selection fields.

When I select shipments that are Late, the performance meter goes over 1000% :S, which is complete wrong.

Is my expression set right? or do I need to add something else to my expression? or is the problem somewere else.

I've attached my qlikview.

Hope u can help me out!!

Thanks in advance

iSam

problems with a gauge chart

Tue, 13 Sep 2011 14:23:46 GMT

Hello iSam,

if you do not want that the current user selections influence your expression(s) in your gauge chart you can use the "1" within this expression. Details see Online-Help

Similar to this:

Count({ 1 <Status={OnTime}>} Destination) / Count ( {1} Destination)

Regards, Roland

Re: problems with a gauge chart

Anonymous — Tue, 13 Sep 2011 14:43:23 GMT

Hi Ronald,

Well actually I do want the users to see the gauge changing based, if they select ‘Q3’ you see the right performance.

However things go wrong when the user selects the shipments that are ‘late’. The meter then goes over 1000% :S

Hope u can help!

Cheers

problems with a gauge chart

Tue, 13 Sep 2011 15:05:52 GMT

Hello again,

may be my answer was too fast (and furious 😉 )

Try this one:

Count({<Status={OnTime}>} Destination) / Count ( {<Status= >} Destination)

This is the ratio between "OnTime Destinations" and "All Destinations" regardless a Status but including all other selections.

HtH

Roland

problems with a gauge chart

SunilChauhan — Tue, 13 Sep 2011 15:08:23 GMT

Count( Destination)/ Count ({1} Destination)

hope this help