topic Re: Mini Bar Chart inside Straight table in QlikView

Mini Bar Chart inside Straight table

udaya_kumar — Tue, 12 Aug 2014 07:30:17 GMT

Hi,

I have a straight table, i need to get horizontal bar chart inside a cell.

I am not able to attach the image in office.

Is it possible to achieve it in straight table?

It looks like this one below

Bar chart should be based on the value of the dimension's volume, but it should start from 0 point, if it is negative, then it should go toward left in red color, if the value is positive, then it should go towards right in green color

Header 1	Bar Chart
A	IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII
B	IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII
C	IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII

Re: Mini Bar Chart inside Straight table

Anonymous — Tue, 12 Aug 2014 07:32:17 GMT

Expressions->Representation->Mini Chart

Re: Mini Bar Chart inside Straight table

Tue, 12 Aug 2014 07:41:47 GMT

This post might be helpful: Straight Table chart with linear gauge chart

Fredrik

Re: Mini Bar Chart inside Straight table

Tue, 12 Aug 2014 08:01:58 GMT

Hi Uday,

Mini Charts works for Staright table.

Select Staright Table in the Chart Object-->Go to Expressions-->Representation-->Select Mini Chart from Drop down-->Click on Mini Chart Settings-->Select Whiskers from the Drop down and see how it goes.

Praveen

Re: Mini Bar Chart inside Straight table

tresB — Tue, 12 Aug 2014 08:11:10 GMT

Mini chart's Min - Max value setting is global for the object, it can't be made variable with dimension vaules.

Re: Mini Bar Chart inside Straight table

udaya_kumar — Tue, 12 Aug 2014 09:41:12 GMT

Hi all,

Thanks for the reply.

I tried using linear gauge for an expression.

I am getting data like this

Volume	Bar Chart
200	IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII
300	IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII
-100	I

But i want like

Volume	Bar Chart
200	IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII
300	IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII
-100	IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII

Can we achieve this?