topic Re: bars in pivot table in QlikView

bars in pivot table

Thu, 17 Sep 2015 05:45:18 GMT

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

Re: bars in pivot table

jafari_ervin — Thu, 17 Sep 2015 06:04:54 GMT

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.

Re: bars in pivot table

Thu, 17 Sep 2015 07:35:16 GMT

I need to show the output in this form.

Re: bars in pivot table

tresB — Thu, 17 Sep 2015 07:42:28 GMT

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

Re: bars in pivot table

Thu, 17 Sep 2015 18:43:15 GMT

‌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

Re: bars in pivot table

Fri, 18 Sep 2015 06:08:21 GMT

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

Re: bars in pivot table

tresB — Fri, 18 Sep 2015 06:13:48 GMT

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

Re: bars in pivot table

Fri, 18 Sep 2015 08:30:36 GMT

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

Re: bars in pivot table

Sun, 03 Sep 2017 18:25:00 GMT

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

Re: bars in pivot table

vinieme12 — Sun, 03 Sep 2017 19:26:04 GMT

Check the attached

Re: bars in pivot table

Mon, 04 Sep 2017 16:03:35 GMT

Thanks Vineeth. Inside the repeat expression, what are you using? Is that a color bar/image or text expression. I cannot view the objects in your file since it is a qvw file which I am opening in Qliksense.