Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
please find the attchments
You can make a combination of the fields using the "&" operator.
Group & '-' & SubGroup
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
If I understand your question correctly, yes you can combine as many dimension fields as you want using the & operator.
Group & '-' & SubGroup & '-' & Customer
-Rob