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:

      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.