topic Re: How to create a column derived from 2 existing columns in QlikView

How to create a column derived from 2 existing columns

john_henry — Wed, 25 Nov 2020 16:16:04 GMT

I need to create a column/dimension that is derived from values in 2 other columns.

Derived Column logic: if Price A is $0 or NULL, use Price B, else Price A

lironbaram — Wed, 07 Aug 2019 05:48:30 GMT

in your load script

write something like this :

load

PriceA,

PriceB,

if(PriceA>0,PriceA,PriceB) as Price

From XXXX

Siva_Sankar — Wed, 07 Aug 2019 05:49:28 GMT

Try: IF([Price A]='$0' or [Price A]='',[Price B],[Price A])

Attached Qvw

john_henry — Wed, 07 Aug 2019 19:43:56 GMT

Thanks for the suggestion...I'll use it if I need to create a column from the load script.

john_henry — Wed, 07 Aug 2019 20:00:24 GMT

thanks...this works!