how to combine two list boxes(dimensions) in to one dimension in qlikview bar chart ASAP

[SNR1]

HI All,

how to combine two list boxes(dimensions) in to one dimension in qlikview bar chart  ASAP

i have two list boxes one is group and another one is sub group.

i want to combine both boxes or dimensions in to single one to show in bar chart

in bar chart i need to create a static chart with many dimensions with 7 expressions.

how we can create static bar chart for this

in dimensions must be year and another dimension is with group and sub group.

for each and ever year for group values should be static based on sub region.

Thanks in Advance.

[sunny_talwar]

Your attachment is completely empty. There is no script or data in the attached app

[SNR1]

please find the attchments

[rwunderlich]

You can make a combination of the fields using the "&" operator. 

Group & '-' & SubGroup

[SNR1]

Hi Rwunderlich,

Is it possible to combine more than 3 dimensions int o single because here i have more than 3 expressions values to show and i have more dimensions 

so i want to combine dimensions to show multiple expression in stack bar.

Thanks in Advance

[rwunderlich]

If I understand your question correctly, yes you can combine as many dimension fields as you want using the & operator. 

Group & '-' & SubGroup & '-' & Customer

-Rob