Discussion board where members can get started with QlikView.
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
Try: IF([Price A]='$0' or [Price A]='',[Price B],[Price A])
View solution in original post
in your load script
write something like this :
if(PriceA>0,PriceA,PriceB) as Price
Thanks for the suggestion...I'll use it if I need to create a column from the load script.