topic GaugeChart doesn't change when selection is changing in QlikView

GaugeChart doesn't change when selection is changing

Thu, 05 Jul 2012 06:55:10 GMT

Hi,

i have a Gauge chart that should respond when i make selections in my Listboxes. For now it only calculates tyhe percentage once.

I would like to present the percentage of meldingen that are intime.

I have the following table:

Meldingen:

LOAD

DATAAREAID,

NOTIFICATIONID,

CBSDISTRICTID,

CBSNEIGHBOURHOODID,

DISTURBANCEDESCRIPTION,

DISTURBANCEID,

STATUS AS MeldingStatusID,

DATE(FLOOR(NUM(REGISTRATIONDATETIME))) as REGISTRATIONDATETIME,

DATE(FLOOR(NUM(DEALBEFOREDATETIME))) as DEALBEFOREDATETIME,

DATE(FLOOR(NUM(CLOSEDDATETIME))) as CLOSEDDATETIME,

IF (CLOSEDDATETIME > DEALBEFOREDATETIME, 0,1) as INTIME

;

The expression in mij Gauge is as follows:

=Sum(INTIME)/Count(NOTIFICATIONID) *100 &'%'

In my opinion is SUM(INTIME) the number of meldingen that are in time, and count NOTIFICATIONID the total of meldingen

Can anybody help me?

Anonymous — Thu, 05 Jul 2012 06:57:00 GMT

Hi Jeroen,

Could you upload a small example application to illustrate the problem?

Thu, 05 Jul 2012 06:59:50 GMT

I uploaded a file within my original post.

Thnx for responding!

Anonymous — Thu, 05 Jul 2012 07:31:35 GMT

1. Go to Expression tab: Uncheck"Relative" checkbox

2. Go to Presentation tab: Uncheck "Show labels on every.." checkbox.

This should work