Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sheikhshafeeq
New Contributor

How to include only one category in the field for gauge visualisation in qliksense

Hi all,

I'm trying to create a gauge visualization by selecting only one category in the field. Kindly refer below for the data:

xx.JPG

I'm trying with below syntax but it doesn't work.

=only({<[Category of Commitment] = {'Well'}>} (sum([Commitment Status])/sum[Commitment]))

May i know why the syntax doesn't work and what is the correct syntax for this?

Thank you.

1 Reply
Employee
Employee

Re: How to include only one category in the field for gauge visualisation in qliksense

The only function is designed to look into the raw fields and select a field value if it only has one.

It looks like you only need a sum aggregation with your set analysis in each component:

sum({<[Category of Commitment] = {'Well'}>} ([Commitment Status])/sum{<[Category of Commitment] = {'Well'}>} [Commitment]))

Community Browser