Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Gauge Chart

Hi

I'm trying to make a gauge chart. I have a table with some data of operations. Then there is a column that can be "approved" or "not approved". I want to make a gauge chart of % of approved operations, but I can't find a way to do it.

Thanks

1 Solution

Accepted Solutions
kidbank3
Contributor III

Re: Gauge Chart

try

count({<Status={'A'}>}Operation)/

count(Operation)

4 Replies
kidbank3
Contributor III

Re: Gauge Chart

Ivan,

You should be able to simply add your calculation under measures.  something like count({<approval={'approved'}>}operations)/count(operations)

Can you provide a specific example?

Mike

Not applicable

Re: Gauge Chart

Certainly

The table, named ACUM, is like this:

OperationDescriptionStatus
1BuyA
2BuyO
3SellA

I want to make a gauge with % of As (eventually, I would like to also filter them by Buy/Sell).

kidbank3
Contributor III

Re: Gauge Chart

try

count({<Status={'A'}>}Operation)/

count(Operation)

Not applicable

Re: Gauge Chart

Thanks! It worked

Community Browser