topic Group or merge dimension in QlikView

Group or merge dimension

gauthamchilled — Thu, 03 Dec 2015 08:05:18 GMT

hi,

I have two dimensions or two levels and want to make it one. something like the attached example. how can I achieve this?

only for specific counties, I want to use the continent name instead of displaying all the countries in the pivot table.

Pls help

Gautham

tresB — Thu, 03 Dec 2015 08:16:48 GMT

Load *, If(continent='Asia', country, continent) as NewDim inline

[

continent,country,sales

Asia,India,120000

Asia,Singapore,540000

Asia,Thailand,2434321

Europe,Netherlands,1234123

Europe,Norway,23422323

Africa,Uganda,123123

];

Anonymous — Thu, 03 Dec 2015 08:19:53 GMT

I dont think that this exactly you can do same but workaround like:

1) You can use Statistics Object to represent in same way, see this:

2) Continent&'-'&Country as NewDim //Composing both the fields

Anonymous — Thu, 03 Dec 2015 08:23:15 GMT

Ohh, misunderstood the requirement. see Tresesco suggestion

gauthamchilled — Thu, 03 Dec 2015 08:38:45 GMT

Tresesco,

Thanks. I want to do for several other dimensions not just for Asia, but to be grouped under Newdim. How can I do that.

i.e Based on second dimension values I want to group them and show as new dimension.

Thanks for the help.

Gautham.

Anonymous — Thu, 03 Dec 2015 08:42:49 GMT

You need to hardcode in the same way with multiple if statements like:

If(continent='Asia', country,

If(continent='XYZ', country,

If(continent='ABC', country,

and so on....
continent))) as NewDim

tresB — Thu, 03 Dec 2015 08:46:47 GMT

Try like:

If(Match(continent='Asia','OtherContinent1' , 'OtherContinent2') country, continent)