Create a new dimension

[#1]

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.

[sujeetsingh]

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

[fosuzuki]

Try this:

LOAD RecNo() AS X

AutoGenerate(3);

[MayilVahanan]

Hi

Try like this

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