topic Create a new dimension in QlikView

Create a new dimension

Wed, 16 Jan 2013 13:23:02 GMT

Dear everybody

I`m a Qlik View beginner and I try to make a simple diagram. I have an excel sheet with some dimension. One dimension is the status which has 5 distinct values (1, 2, 3, 4, 5). Now I want to create a new dimension, which includes the value 1 til 3 from the dimension above. How can I do this?

Don`t laugh, beginners-life is very hard.

Thank a lot for your help.

Re: Create a new dimension

sujeetsingh — Wed, 16 Jan 2013 13:37:47 GMT

It means you are trying to get a dimension from the exsisting one just write as

Load...

field1

,field2

,if(field1>=3,Field1,Missing) as New Dimension

Hope this help you

Re: Create a new dimension

fosuzuki — Wed, 16 Jan 2013 13:38:44 GMT

Try this:

LOAD RecNo() AS X

AutoGenerate(3);

Re: Create a new dimension

MayilVahanan — Wed, 16 Jan 2013 13:54:46 GMT

Try like this

Load field1,field2 ,if(field1 <=3,field1) as New Dimension from tablename;