topic Re: Barchart in QlikView

Barchart

Fri, 14 Nov 2014 12:29:11 GMT

Hello everybody,

i have a problem. I created a Barchart, look here...

X is my AREA.

Blue is reserved and red is free.

So i want, if i click on the blue colour...The Barchart show me the Area Y and Z, such us here...

Example: I click on the Blue Colour, then the Bar chart show me...Area (Pink) Y has 20% , Area Z (green) has 10%, and

Area Q ( Yellow) has 70 %

I hope, you understand my problem.

many thanks.

Regards benny

Re: Barchart

jpenuliar — Fri, 14 Nov 2014 12:34:25 GMT

Hi seems to me like you have a drill-down of dimensions,

Dimension 1 contains (reserved,free)

dimension 2 contains (Area Y, area z, area Q)

Re: Barchart

giakoum — Fri, 14 Nov 2014 12:34:55 GMT

I dont really understand but lets try.

If X is a dimension, and you need to click on it and drill down to some other dimension, then you need to create a group and use the group as a dimension.

For example :

Group Organisation consisting of:

Department

Section

Team

By clicking on the bar, when looking at Department, you will be drilled down to Section etc.

Re: Barchart

jpenuliar — Fri, 14 Nov 2014 12:50:56 GMT

If in case, you need a sample Drill Down:

How to drill down in QlikView

Re: Barchart

jyothish8807 — Fri, 14 Nov 2014 13:08:59 GMT

Hi Benjamin,

Can you share your sample data, this is possible to do in QV.

Regards

Re: Barchart

Mon, 17 Nov 2014 12:09:40 GMT

Thanks for the help.

my problem ist solved