Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
akpofureenughwu
Contributor III

How to create a pie chart without dimension on qliksense

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

1 Solution

Accepted Solutions
OmarBenSalem
Esteemed Contributor

Re: How to create a pie chart without dimension on qliksense

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:

Capture.PNG

2 Replies
OmarBenSalem
Esteemed Contributor

Re: How to create a pie chart without dimension on qliksense

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:

Capture.PNG

akpofureenughwu
Contributor III

Re: How to create a pie chart without dimension on qliksense

Thank you omarbensalem