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

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

SNR1 — Mon, 17 Dec 2018 17:26:14 GMT

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 — Mon, 17 Dec 2018 17:46:47 GMT

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

SNR1 — Mon, 17 Dec 2018 18:22:44 GMT

please find the attchments

rwunderlich — Mon, 17 Dec 2018 21:34:47 GMT

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

Group & '-' & SubGroup

SNR1 — Tue, 18 Dec 2018 02:56:31 GMT

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 — Tue, 18 Dec 2018 19:31:46 GMT

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

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

-Rob