Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am very new to using Qlikview and I am trying to count how many projects are amber and dispaying it in a gauge chart.
I have tried Count({[Status)]={'Amber'}Title) and sum(if(len(trim([Status)]))>0,1,0)) but the gauge chart disappears once I execute.
I have looked at previous discussions and tried to use those expressions but again doesnt seem to be working.
Any suggestions be appreciated?
Thanks.
Darragh
Title | Status |
---|---|
Project 1 | Amber |
Project 2 | Amber |
Project 3 | Amber |
Project 4 | Amber |
Project 5 | Amber |
Project6 | Amber |
Try the following expression:
= count ( { <Status={'Amber'}>} Distinct Title )
Try something like :
= count ( { <Status={'Amber'}>} Status )
Hi Darragh
Can you please provide some more information for this issue that will help me to fix up the issue. what exact do you required as far as i know Gauge is usefully for the Range type of graph like in between you have put some function and based on that get the result.
Hi Saumil,
Thanks for your message.
Sure- I am looking to show on a gauge chart how many projects are in "Amber".
Using the above table I am trying to create an expression that will text count the number of ambers. (i.e. 6 projects are "Amber" from the table) I will be doing this similiarly to Projects that are "Green" and "Red" but once I able to get the "amber " expression I should be able to use the same expression but subtituting "Amber" for "Green" and "Red".
Regards,
Darragh
Hi,
may be like this.
Regards
ASHFAQ
Hi Ashfaq,
Unfortunately I have the personal edition so unable to open documents created by other users. Are you able to send the formulae free text?
Thanks,
Regards,
Darragh
Try the following expression:
= count ( { <Status={'Amber'}>} Distinct Title )
Looks like it worked! Thanks for your help Nagaian and all! 🙂
Regards,
Darragh