Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

GaugeChart doesn't change when selection is changing

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?

1 Solution

Accepted Solutions
jsn
Honored Contributor

Re: GaugeChart doesn't change when selection is changing

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

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

This should work

3 Replies
jsn
Honored Contributor

Re: GaugeChart doesn't change when selection is changing

Hi Jeroen,

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

Not applicable

Re: GaugeChart doesn't change when selection is changing

I uploaded a file within my original post.

Thnx for responding!

jsn
Honored Contributor

Re: GaugeChart doesn't change when selection is changing

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

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

This should work

Community Browser