topic Re: Stacked bar in a Straight table in QlikView

Stacked bar in a Straight table

Thu, 03 Jul 2014 07:17:45 GMT

Hi All,

I need to show Actual Sales vs Target to be achieved in a straight table. I have been asked to visualize it using a stacked bar chart, but a stacked bar chart is not feasible in a straight table. So it will be great if anyone of you can suggest some other way of representing the sales and the target figures.

Re: Stacked bar in a Straight table

Thu, 03 Jul 2014 07:27:42 GMT

You can use Bar chart

Re: Stacked bar in a Straight table

aveeeeeee7en — Thu, 03 Jul 2014 07:32:05 GMT

Hi Rahul

For showing Actual Sales vs Target, Bar Chart is the Best option.

Just use the dimension for which you have to show Actual Sales vs Target.

eg. 1. Select Bar Chart

2. Select Region in Dimension

3. You need to add 2 Expressions: one for Actual Sales & Other for Target

Regards

Aviral

Re: Stacked bar in a Straight table

Thu, 03 Jul 2014 08:07:15 GMT

Hi Aviral,

Thanks for the reply.

But what I need is only one horizontal stacked bar per row of the straight table as one row represents on state code in the table. And the bar should be for the same state code.

Regards,

Rahul