Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

bars in pivot table

how to show bars in a pivot table with length corresponding to the field values group by another field?

10 Replies
jafari_ervin
Creator III
Creator III

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.

Not applicable
Author

sales.png

I need to show the output in this form.

tresesco
MVP
MVP

Use Linear Gauge as the 'Display Option' for your expression.

Untitled.png

Not applicable
Author

‌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

Not applicable
Author

colours should be different. Using linear gauge all bars are in same colour.

tresesco
MVP
MVP

Expand the '+' sign of the expression (for the gauge), there you can set the background colors conditionally based on dimension members or such.

Not applicable
Author

but i need to show different colors only on bar not on background as shown in above uploaded screen shot

Not applicable
Author

Is there a way to show similar color bars in a pivot table in Qlik Sense?

vinieme12
Champion III
Champion III

Check the attached

NotLinearGauge.JPG

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.