topic Re: stacked bar chart 2x dimensions in QlikView

stacked bar chart 2x dimensions

Wed, 25 Nov 2020 16:16:04 GMT

I want to show a stacked bar chart, with dimensions targets and actuals side by side - any ideas ?

Re: stacked bar chart 2x dimensions

sunny_talwar — Wed, 16 Nov 2016 14:15:17 GMT

Would you be able to provide a sample with how you expect to see your chart?

Re: stacked bar chart 2x dimensions

Wed, 16 Nov 2016 14:20:24 GMT

Something like below -targets are pulled in separately to the main load script - the volumes are labelled tarvol and acvol (new to Qlikview so not sure what I am doing) I've tried all ways I can find on Google with the Value list being the closest I have come ...

Re: stacked bar chart 2x dimensions

kaushiknsolanki — Wed, 16 Nov 2016 14:21:14 GMT

Hi,

Check below links.

2-dimension / 2-expression bar chart question

Regards,

Kaushik Solanki

Re: stacked bar chart 2x dimensions

vinieme12 — Wed, 16 Nov 2016 18:59:10 GMT

can you post sample data that replicates your scenario

Re: stacked bar chart 2x dimensions

Thu, 17 Nov 2016 09:20:32 GMT

Hello Vineeth -

I have my main load

date band obs

Jan £0-£15 300

Jan £15-30 400

Jan £30-£45 500

Jan £45-60 100

Jan £60+ 50

feb mar same with diff vol

second load is targets

date (linked to the date in the first load)

volume 100

150

200

300

does that make sense ?

Re: stacked bar chart 2x dimensions

kaushiknsolanki — Thu, 17 Nov 2016 09:24:00 GMT

Hi,

Not this sample data.

What we are looking is sample QVW file.

See below link for more help.

Preparing examples for Upload - Reduction and Data Scrambling

https://community.qlik.com/docs/DOC-16454

Regards,

Kaushik Solanki

Re: stacked bar chart 2x dimensions

Thu, 17 Nov 2016 10:10:51 GMT

Thank you for your help - this link has helped me to muddle through 🙂