topic Creating a new Dimension from an existing one in QlikView

Creating a new Dimension from an existing one

DellaCruze — Thu, 22 Apr 2021 13:22:18 GMT

Hi everyone,

I want to create a new Dimension from an Existing one.

Just like displayed in this graphic:

I tried it with multiple if-statements in the chart and in the script, but i guess i am too deep into EXCEL 😉
The result was always the first expression like "if(Movement = 1 or 2 or 3 or 14, 'Logistics', if(...)) --> Logitics" but it would never return the other expressions.

Hopefully someone can help and explain to me .

BR and many thanks in advance

Re: Creating a new Dimension from an existing one

jwjackso — Thu, 22 Apr 2021 13:34:11 GMT

Try

If(Movement = 1 or Movement = 2 or Movement = 3 or Movement = 14,'Logistics',If(...))

Pick(Movement,'Logistics','Logistics','Logistics','Production','Production',....)

Re: Creating a new Dimension from an existing one

DellaCruze — Thu, 22 Apr 2021 13:41:29 GMT

Thank you @jwjackso !

The solution was this simple.
Your first suggestion worked flawlessly in the script.