Qlik Community

Community Corner

Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

SNR1
Contributor

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

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.

5 Replies

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

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

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

please find the attchments

MVP & Luminary
MVP & Luminary

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

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

Group & '-' & SubGroup

SNR1
Contributor

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

Hi Rwunderlich

 

MVP & Luminary
MVP & Luminary

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

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

 

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

-Rob