Can I Share stack barchart in two category?

[#1]

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

[#2]

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

Can you share a qvw example?

[#3]

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

[#4]

Hi Mario,

thanks for your help I will attach an exsample.

I Have attach a new exsample

Greetings Sven

[#5]

Hi Sven,

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

Regards

MC

[#6]

Hi Mario,

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

Greetings Sven