Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to show bars in a pivot table with length corresponding to the field values group by another field?
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.
I need to show the output in this form.
Use Linear Gauge as the 'Display Option' for your expression.
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
colours should be different. Using linear gauge all bars are in same colour.
Expand the '+' sign of the expression (for the gauge), there you can set the background colors conditionally based on dimension members or such.
but i need to show different colors only on bar not on background as shown in above uploaded screen shot
Is there a way to show similar color bars in a pivot table in Qlik Sense?
Check the attached