- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
bars in pivot table
how to show bars in a pivot table with length corresponding to the field values group by another field?
- Tags:
- new_to_qlikview
- « Previous Replies
-
- 1
- 2
- Next Replies »
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
you can not use bar chart (mini chart) in pivot table, you can use just from gauge in pivot table.
you can implemented bar with linear gauge in pivot table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I need to show the output in this form.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use Linear Gauge as the 'Display Option' for your expression.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
tthe example shown, though a pivot table looks like a straight table as well
bars can be used in a straight table but if it must be a pivot table, the gauge is the only option I believe to get the look you are trying toachieve
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
colours should be different. Using linear gauge all bars are in same colour.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Expand the '+' sign of the expression (for the gauge), there you can set the background colors conditionally based on dimension members or such.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
but i need to show different colors only on bar not on background as shown in above uploaded screen shot
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Is there a way to show similar color bars in a pivot table in Qlik Sense?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Check the attached
If a post helps to resolve your issue, please accept it as a Solution.
- « Previous Replies
-
- 1
- 2
- Next Replies »