topic how to include a bar chart in straight table in QlikView

how to include a bar chart in straight table

ananyaghosh — Mon, 30 Mar 2015 12:45:50 GMT

Please can any one show me how to include a bar chart in a straight table?

Re: how to include a bar chart in straight table

Anonymous — Mon, 30 Mar 2015 12:52:33 GMT

Choose representation mini-chart for your expression. In mini chart settings, select "Bars" mode and define Dimension. See attached.

Re: how to include a bar chart in straight table

prieper — Mon, 30 Mar 2015 12:53:04 GMT

Have a look into Asfaq's example

http://community.qlik.com/message/572099#572099

Peter

Re: how to include a bar chart in straight table

Mon, 30 Mar 2015 12:55:36 GMT

Hi,

Try bar chart in straight table in expression tab

Re: how to include a bar chart in straight table

PrashantSangle — Mon, 30 Mar 2015 12:59:33 GMT

Hi,

Select Expression->Display Option->select Mini Chart->selct Mini chart Setting->select Bar Mode

Regards

Re: how to include a bar chart in straight table

buzzy996 — Mon, 30 Mar 2015 13:03:14 GMT

try from expression tab --

1. Select ur expression and Select "mini chart" form Display options

2. Click on Mini chart settings --Appearances-Mode as "Bars".

Re: how to include a bar chart in straight table

Mon, 30 Mar 2015 13:04:47 GMT

hII

CHECK THE ATTACHED FILE

In image check this checkboxes and you can see the bar chart in straight chart

Re: how to include a bar chart in straight table

Mon, 30 Mar 2015 13:10:56 GMT

First select the expression that you want to be a mini chart:

And then you open the "Mini Chart Settings" and choose the dimension, the mode of your chart(Bars in your case) and colors:

Hope that helps!

Re: how to include a bar chart in straight table

whiteymcaces — Fri, 05 Jun 2015 02:49:53 GMT

Hi,

I am going to assume that you want to have 1 horizontal bar for each row, and not a mini bar chart on each row.

You will need to create a new expression similar to "Sum(Sales) / Max(Total Aggr(Sum(Sales), [Your Dimension])"

Change Total Mode = No Totals

Then change the Representation = "Linear Gauge".

Gauge Settings (Only 1 Segment)

Min = 0

Max = 1

Mode = Fill to Value

Style = Arrow

Show Scale = False

Autowidth Segments = True

Hide Segment Boundaries = True

Hide Gauge Outlines = True

Colour = Your Choice

Re: how to include a bar chart in straight table

md_qlikview — Fri, 05 Jun 2015 03:24:09 GMT

Change the display option for that expression. You will find it in the same tab i.e. Expression tab. Change it from text to Mini chart. You can set different settings of it by clicking Mini chart setting option right below display option. It will populate as soon as you change display option to Mini chart.