Discussion Board for collaboration on QlikView Layout & Visualizations.
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:
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?
Go to Solution.
1. Go to Expression tab: Uncheck"Relative" checkbox
2. Go to Presentation tab: Uncheck "Show labels on every.." checkbox.
This should work
Could you upload a small example application to illustrate the problem?
I uploaded a file within my original post.
Thnx for responding!