topic straight table in QlikView

straight table

raadwiptec — Sat, 14 Nov 2015 21:39:59 GMT

Hi All,

my expression values for a column is 0.00000 and some are null.

I need a condition in the expression where if the column is null or 0.0000 then populate the value from another column

price ¦ net

0.00000 ¦ 1.24

0.00000 ¦ 1.25

null ¦ 1.26

my expected output should be..so if the price value is null or 0.0000 then it should take value from the net column

price ¦ net

1.24 ¦ 1.24

1.25 ¦ 1.25

1.26¦ 1.26

Re: straight table

sunny_talwar — Sat, 14 Nov 2015 22:26:55 GMT

May be this:

If(price = 0 or Len(Trim(price)) = 0, net, price)

Re: straight table

MarcoWedel — Sun, 15 Nov 2015 01:22:16 GMT

Hi,

one solution could be:

SET NullInterpret='null';

table1:
LOAD If(price,price,net) as price,
    net
INLINE [
    price, net
    0.00000, 1.24
    0.00000, 1.25
    null, 1.26
    0.00001, 1.27
    10, 1.28
];

hope this helps

regards

Marco