topic Bar chart in a table cell? in QlikView

Bar chart in a table cell?

Thu, 17 Nov 2011 09:17:13 GMT

Hi,

At the moment, I have a table cell which displays a percentage.

I'd like to show this as a small bar chart, in the cell.

Is this possible?

Thanks,

Bar chart in a table cell?

Anonymous — Thu, 17 Nov 2011 09:27:54 GMT

yes it's possible.

Go to the expression tab and click on mini chart settings. Now select the dimension you want and then the mode.

Regards,

iSam

Bar chart in a table cell?

Thu, 17 Nov 2011 09:47:55 GMT

Thanks, although I just want a single bar - it's only one % value.

Would that still work?

Re: Bar chart in a table cell?

Anonymous — Thu, 17 Nov 2011 09:57:20 GMT

I think it would work. However it goes above my knowledge L

Re: Bar chart in a table cell?

IAMDV — Thu, 17 Nov 2011 12:27:00 GMT

Hi,

You need to copy the same expression and then you need to change the Representation as Linear Guage. Then click on the Guage Settings and you will see a new window. Under this window you will see Guage Properties, you need to change the Mode (Under Indicator) to Fill to Value. As you wanted to show the percentage(%) instead of actual values, you don't need to change the Min and Max values which are default to 0 and 1 respectively. However, you need to remove the Segment 2 from Segments Setup and you may change the color if you wanted to.

I am also attaching a screenshot of this window. I hope this helps!

Cheers - DV