- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you omarbensalem
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Amazing - I found this first hit to my question and it worked as hoped. Thanks @OmarBenSalem !
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Great solution! Thanks @OmarBenSalem