how to call a calculated value in load

sabrina87 — Tue, 16 Feb 2021 15:52:05 GMT

Hi team,

I am calculating "LOB Criticality" value on the load, and i want to call it back on the same load to do another calculation but it is not working:

LOAD

[name]

[LOB Field]

[criticality]

If ([LOB Field]=1, 'ok','bad') as 'LOB Criticality'

if (len(trim([LOB Criticality]))=0,'blocked','not blocked') as 'blocked Y/N' -- this line is giving me an error. The "LOB Criticality" calculated field seems to be called in the wrong way but i dont know which should be the appropiate one

If someone can help, that will be really helpful

Re: how to call a calculated value in load

mfchmielowski — Tue, 16 Feb 2021 20:05:24 GMT

Hi.

You can use preceding load in this.

Please note that field names with spaces should be in square brackets.

Data: load * , if (len(trim([LOB Criticality]))=0,'blocked','not blocked') as [blocked Y/N] ; LOAD [name] ,[LOB Field] ,[criticality] , If ([LOB Field]=1, 'ok','bad') as [LOB Criticality] inline [ name, LOB Field, criticality a, 0, 1 b, 1, 0 ];

topic how to call a calculated value in load in QlikView

how to call a calculated value in load

Re: how to call a calculated value in load