Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Counting Text and Displaying in a Gauge Chart


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

TitleStatus
Project 1Amber
Project 2Amber
Project 3Amber
Project 4Amber
Project 5Amber
Project6Amber
1 Solution

Accepted Solutions
nagaiank
Specialist III
Specialist III

Try the following expression:

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

View solution in original post

7 Replies
bill_markham

Try something like  :

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

Not applicable

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.

Not applicable

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

Not applicable

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
Specialist III
Specialist III

Try the following expression:

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

View solution in original post

Not applicable

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

Regards,

Darragh