Field value

[dseelam]

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]

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]

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]

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

hope this helps

regards

Marco

[#5]

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

[MarcoWedel]

http://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/ConditionalFunctions/al...