1 Reply Latest reply: Jul 10, 2018 4:57 PM by Lisa Phillips RSS

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

    Sheikh Muhammad Shafeeq Abdul Bareed

      Hi all,


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



      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.