topic Bar Chart with several Dimensions in QlikView

Bar Chart with several Dimensions

alec1982 — Fri, 22 Nov 2013 04:42:14 GMT

Hi guys,

I have a table as follow:

Location Region Amount

A America 500

B America 200

C APAC 300

D APAC 150

E India 200

Assuming that we have a location list box on the dashboard and always one value selected

I need to create a bar chart where the first bar will show the amount of the location and a second bar will show the total amount for the region of that location and a third bar to show the total amount of all locations.

Assuming A is selected on the list boxThe result chart should show the following results:

Location Region All

500 700 1350

Please let me know your thoughts..

Thxs,

Alec

Re: Bar Chart with several Dimensions

Fri, 22 Nov 2013 05:27:13 GMT

Hi,

try this attach file.

Regards,

Ashutosh

Re: Bar Chart with several Dimensions

Fri, 22 Nov 2013 05:33:03 GMT

Hi Badr,

Please find attached the .qvw file..

Hope this helps your problem..

FYI, I have taken a bar chart with no dimension but 3 expression as follows:

1. For Location Amount : sum(Amount)

2. For Region Amount : sum({1<Region={$(=Region)}>} total Amount)

3. For Total Amount : sum({<Location=>}total Amount)

And taken Location as a list box with always one selected value..

Re: Bar Chart with several Dimensions

Fri, 22 Nov 2013 06:13:33 GMT

Hi,

PFA

Re: Bar Chart with several Dimensions

alec1982 — Fri, 22 Nov 2013 16:38:35 GMT

Thank you guys.. all the solutions are correct