topic Re: Can I Share stack barchart in two category? in QlikView

Can I Share stack barchart in two category?

Thu, 30 Jan 2014 10:41:02 GMT

hello everybody,

it is possible to share a stack barchart with two different catagory.

To explain: I have case and cubic and this fields are shared in to possible and not possible. so i have 4 bars. I want to stack case possible and not possible and cubic posssible and not possible in one barchart. It is possible?

Now all bars where stack.

Thanks foe your help.

greetings Sven

Re: Can I Share stack barchart in two category?

Thu, 30 Jan 2014 10:58:07 GMT

Yes, try to add a custom dimension in load script...

Can you share a qvw example?

Re: Can I Share stack barchart in two category?

Thu, 30 Jan 2014 11:06:52 GMT

in script:

Load

Dim1,

Dim2,

if(Dim1='Case' and Dim2='Not Possible', 'Case Not Possible',

if(Dim1='Case' and Dim2='Possible', 'Case Possible',

if(Dim1='Cubic' and Dim2='Possible', 'Cubic Possible',

if(Dim1='Cubic' and Dim2='Not Possible', 'Cubic Not Possible')))) as Dim3

from ....

and then use Dime 3 as Dimension of bar chart stacked.

I hope this helps

Re: Re: Can I Share stack barchart in two category?

Thu, 30 Jan 2014 11:55:57 GMT

Hi Mario,

thanks for your help I will attach an exsample.

I Have attach a new exsample

Greetings Sven

Re: Can I Share stack barchart in two category?

Mon, 03 Feb 2014 17:59:40 GMT

Hi Sven,

please explains me what is your problem with sample barchart.qvw...

Regards

Re: Can I Share stack barchart in two category?

Wed, 05 Feb 2014 08:52:39 GMT

Hi Mario,

in sample barchart is no problem. I think I have clear the problem with an Inline Table in script.

Greetings Sven