How to create a pie chart without dimension on qliksense

[akpofureenughwu]

Good day sir,

I have a set of data and I wish you develop a pie chart with two measures and no dimension.

Sample data is attached

The pie chart is to solve a relationship between uptime and downtime

I know this is possilbe in qlikview. how about qliksense?

Regards

[OmarBenSalem · Accepted solution]

As dimension :

=ValueList('Uptime','Downtime')

as a measure:

if(ValueList('Uptime','Downtime')='Uptime',Count({<Uptime={1}>}Uptime),

if(ValueList('Uptime','Downtime')='Downtime',count({<Downtime={1}>}Downtime)))

result:

[akpofureenughwu]

Thank you omarbensalem

[Tyler_Waterfall]

Amazing - I found this first hit to my question and it worked as hoped. Thanks @OmarBenSalem !

[Amit_Kakkad_PD]

Great solution! Thanks @OmarBenSalem