topic Re: Multiple Dimensions concatenate as one dimension in QlikView

Multiple Dimensions concatenate as one dimension

Wed, 19 Aug 2015 12:52:22 GMT

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

Re: Multiple Dimensions concatenate as one dimension

Gysbert_Wassenaar — Wed, 19 Aug 2015 13:19:01 GMT

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

];

Re: Multiple Dimensions concatenate as one dimension

jonathandienst — Wed, 19 Aug 2015 13:23:27 GMT

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

Re: Multiple Dimensions concatenate as one dimension

Wed, 19 Aug 2015 13:39:10 GMT

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.