topic Re: Counting Text and Displaying in a Gauge Chart in QlikView

Counting Text and Displaying in a Gauge Chart

Mon, 25 Aug 2014 10:39:44 GMT

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

Re: Counting Text and Displaying in a Gauge Chart

Anonymous — Mon, 25 Aug 2014 10:50:27 GMT

Try something like :

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

Re: Counting Text and Displaying in a Gauge Chart

Mon, 25 Aug 2014 10:56:57 GMT

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.

Re: Counting Text and Displaying in a Gauge Chart

Mon, 25 Aug 2014 11:13:16 GMT

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

Re: Counting Text and Displaying in a Gauge Chart

ashfaq_haseeb — Mon, 25 Aug 2014 11:20:29 GMT

Hi,

may be like this.

Regards

ASHFAQ

Re: Counting Text and Displaying in a Gauge Chart

Mon, 25 Aug 2014 13:28:55 GMT

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

Re: Counting Text and Displaying in a Gauge Chart

nagaiank — Mon, 25 Aug 2014 13:39:13 GMT

Try the following expression:

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

Re: Counting Text and Displaying in a Gauge Chart

Tue, 26 Aug 2014 09:49:09 GMT

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

Regards,

Darragh