Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiple Dimensions concatenate as one dimension

Hi,

I have the following table

Region     District

RA          D1

RA          D2

RA          D3

I want to make a bar chart which will have the following dimensions:

RA,D1,D2,D3

I tried using valuelist but it is showing "ERROR IN CALCULATED DIMENSION"

Thanks

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Create a new field in the script and use that field as dimension:

Load Region as ReportRegion, District Inline [

Region,     District

RA,          D1

RA,          D2

RA,          D3

D1,          D1

D2,          D2

D3,          D3

];


talk is cheap, supply exceeds demand
jonathandienst
Partner - Champion III
Partner - Champion III

Please post sample qvw that shows what you are trying to do.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable
Author

Thanks gwassenaar for the reply.

The intention is to select a sales hierarchy and then compare values with both upper and lower hierarchies in a bar chart.

I already have a dimension table which has the mapping for region,district and area. Is it possible to get the said requirement by using a calculated dimension?

^

|

|                                   __          __

|    ___                        |     |     |        |

|    |     |        ____       |     |     |        |

|    |     |        |     |        |     |     |        |

|__|__ |____|__ |____|__ |__ |____|________________>

     Nation     Area     Region  District

This is how the chart is supposed to look if I select 'Region'.

Hope I am clear.