Counting Text and Displaying in a Gauge Chart

[#1]

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

[Anonymous]

Try something like  :

     = count ( { <Status={'Amber'}>} Status )

[#3]

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.

[#4]

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

[ashfaq_haseeb]

Hi,

may be like this.

Regards

ASHFAQ

[#6]

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

[nagaiank · Accepted solution]

Try the following expression:

  = count ( { <Status={'Amber'}>} Distinct Title )

[#8]

Looks like it worked! Thanks for your help Nagaian and all! 🙂

Regards,

Darragh