dynamically get the values

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

Hi,

LogicalCode	FIELD1	FIELD2	FIELD3	FIELD4
44111002	MC	IN	RF
44111002	MC	IN	RFLCE
44111002	MC	IN	RFLCEFULL
44111002	MC	IN	CPGN
44111002	CR	IN	GOODWL
44111002	CR	IN	ECPRF
44111002	CR	IN	MCPRF
44111002	CR	IN	MIRF
44111002	CR	IN	ROAMRF
44111002	CR	IN	SMSRF
44111002	CR	IN	OTTRF
44111002	CR	IN	OFVC
44111002	LN	IN
44111002	LN	RD
44111002	WB	CC
44111002	UD	CC
44111002	FS	CC
44111002	RP	CC
44111002	CO	CC
44111002	WB	BN
44111001	FS	BN		CIMB-EPK
44111001	FS	BN		PBB

i have a straight table in that field1 feild2 feild3 are there and i want to add logical code but i want to show logical code based on feild4 value if it is null go for feild3 if it is also null feild2 but the logic is need to create dynamically that means in future they add the feilds then also works from field5 then field4 like that

for example :

field4 have null in first record so went to field3 RF logical value is 441111002

field 4 have the value PBB directly show 44111001

in future may add one more field5 it needs to compare the same dynamically without writing the logic again

topic dynamically get the values in QlikView

dynamically get the values