topic Bar in Straight Table or in Pivot Table in QlikView

Bar in Straight Table or in Pivot Table

rathnam_qv — Thu, 10 Apr 2014 07:21:57 GMT

Hi All,

How to create Bars in Straight Table or in Pivot Table.

PFA image for Example.

can anyone help me.

Regards,

Rathnam.

Re: Bar in Straight Table or in Pivot Table

its_anandrjs — Thu, 10 Apr 2014 07:27:12 GMT

Use mini chart function for this in charts

Convert your expression into Linear Guage

See the attached snap shot

Re: Bar in Straight Table or in Pivot Table

jagan — Thu, 10 Apr 2014 07:35:19 GMT

Hi,

Please find attached file for solution.

Regards,

Jagan.

Re: Bar in Straight Table or in Pivot Table

rathnam_qv — Thu, 10 Apr 2014 09:55:41 GMT

Hi Jagan Mohan,

Thanks For ur reply.

Is it possible to plot values on Data points in this chart (as we do in Bar chart).

Regards,

Rathnam.

Re: Re: Bar in Straight Table or in Pivot Table

jagan — Thu, 10 Apr 2014 10:41:54 GMT

Hi,

You can create one more expression, pfa file for solution. There is no direct solution, it is not possible like regular bar chart.

Regards,

Jagan.

Re: Re: Bar in Straight Table or in Pivot Table

its_anandrjs — Thu, 10 Apr 2014 11:01:25 GMT

For any expression you can create many charts but use it different ways

Exp1:- Sum(SalesValue) value on data points

Exp2:- Sum(SalesValue) use as minichart

Exp3:- Sum(SalesValue) use ase Circular guage

Exp4:- Sum(SalesValue) use as Linear Guage

Exp5:- Sum(SalesValue) use as LED guage

Re: Re: Re: Bar in Straight Table or in Pivot Table

Thu, 10 Apr 2014 12:21:26 GMT

Anand,

you may also try with "Trellis" Bar Chart (you may turn it on on Dimension Tab). Unfortunetely i don;t think that it will be possible to have only one Dimension values list.

Maybe there is something more in Qlik.Next????

regards

Darek