topic Re: Field value in QlikView

Field value

dseelam — Tue, 13 Sep 2016 18:32:01 GMT

Hello All,

strange requirement

I have this a sight table in a DB where I have 2 dim and 2 expressions and 2 other dimensions as expressions

customer	account	old LOH	old L	new LOH	new L
COSTCO	3245	0.56	0.11	0.56	0.11
AMAZON	4546	0.25	0.26	0.25	0.26
WALMART	1525	0.11	0.45

New LOH & new L Walmart values are blank so there I want to reflect old LOH & old L values

is it even possible ?

Thanks,

Dinesh

Digvijay_Singh — Tue, 13 Sep 2016 18:49:27 GMT

You may try something like -

If(isnull(Exp(newLOH)),Column(1),Exp(newLOH)

Here Column(1) denotes to old LOH exp and Column(2) denotes to old L exp.

instead of isnull you can check len() to 0 as well.

vishsaggi — Tue, 13 Sep 2016 19:11:57 GMT

Extending to what Digvijay mentioned use Len() function like

Dims: Customer, Account

Expr1: OldLOH

Expr2: OldL

Expr3: = IF(Len(NewLoh)=0, oldLOH, NewLoh)

Expr4: = IF(Len(NewL)=0, oldL, NewL)

MarcoWedel — Tue, 13 Sep 2016 20:00:32 GMT

Alt([new LOH], [old LOH])

hope this helps

regards

Marco

Tue, 13 Sep 2016 21:23:13 GMT

if(isNull([new LOH]), [old LOH], [new LOH])

MarcoWedel — Tue, 13 Sep 2016 22:29:27 GMT