topic Doubt about one Dimmension in QlikView

Doubt about one Dimmension

Wed, 07 Jan 2015 19:37:05 GMT

I have two fields (they are in the same table)

Country 1: Arg, Brazil, etc

Country 2: Spain, Italia, etc.

I wanna have the dimension "Countrys" with all the values in the same field.

What should i do?

Thank ya

PD: I forgot to say that if i have Country 1 i NEVER have country 2 and if i have country 2 i NEVER have country 1. I won't have "country 1 and 2"

saurabh5 — Wed, 07 Jan 2015 19:51:46 GMT

hi Jeremias,

you can create a new field by concatinating and then triming any tailing spaces like;

trim(Country1&Country2) as Countrys,

fkeuroglian — Wed, 07 Jan 2015 19:54:18 GMT

Jeremias

see this, good luck

Fernando

Wed, 07 Jan 2015 19:58:04 GMT

Thank you! This is useful.

The "trim" worked too.

jpapador — Wed, 07 Jan 2015 20:29:53 GMT

If 1 is always null you could write an If statement like this:

If(Len(Country1) = 0, Country2, Country1) as Country