topic Re: Create a column with values from other column in QlikView

Create a column with values from other column

Tue, 10 Nov 2015 15:47:42 GMT

I have a column with numerical values (Mostly 0 and 1). I need to create another column/field from the other column on a condition.

If the values in the Column A are > 0, then the Column B should contain those greater than values.

sunny_talwar — Tue, 10 Nov 2015 16:21:16 GMT

May be this:

LOAD [Column A],

If([Column A] > 0, [Column A]) as [Column B]

FROM ....

This will make column B only have values when it is greater than 0. When Column A is 0 or less than 0, Column B will be null.

Is this what you want?

swuehl — Tue, 10 Nov 2015 16:21:20 GMT

LOAD

ColumnA,

IF(ColumnA >0 , ColumnA) AS ColumnB

FROM YourSource;

Tue, 10 Nov 2015 16:36:11 GMT

Is there any way I can use an expression and create this column/field in the Straight Table?

sunny_talwar — Tue, 10 Nov 2015 16:56:09 GMT

Sure, use this as your expression:

If([Column A] > 0, [Column A])

Anonymous — Tue, 10 Nov 2015 18:42:38 GMT

If(column(1) > 0, column(1))

where 1 is the number of expression column in your Straight Table or you can use the name of your expression

if(ExpresionName>1,ExpresionName)

Regards.

Tue, 10 Nov 2015 18:49:43 GMT

Thanks Guys. Got it

sunny_talwar — Tue, 10 Nov 2015 19:12:45 GMT

Great, Close the thread in that case