Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Can I Share stack barchart in two category?


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

5 Replies
Not applicable

Re: Can I Share stack barchart in two category?

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

Can you share a qvw example?

Not applicable

Re: Can I Share stack barchart in two category?

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

MC

Not applicable

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

Hi Mario,

thanks for your help I will attach an exsample.

I Have attach a new exsample

Greetings Sven

Not applicable

Re: Can I Share stack barchart in two category?

Hi Sven,

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

Regards

MC

Not applicable

Re: Can I Share stack barchart in two category?

Hi Mario,

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

Greetings Sven

Community Browser