topic Re: Why null values stored in variables in QlikView

Why null values stored in variables

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

Hi all,

In the below screenshot, I've got null values in variables as marked in the screenshot. Please anyone could say what I did wrong in the script?

LOAD VarCustomer, IN, OUT

FROM (biff, embedded labels, table is Sheet1$);

let noRows = NoOfRows('A');

TRACE '$(noRows)';

for i=1 to $(noRows)

TRACE '----------------------------------------------';

TRACE '$(i)';

let vVar= FieldValue('VarCustomer',$(i)) ;

let vOriginFormat = FieldValue('IN',$(i));

let vDestinationFormat = FieldValue('OUT',$(i));

TRACE '$(vVar)';

TRACE '$(vOriginFormat)';

TRACE '$(vDestinationFormat)';

next i

EXIT SCRIPT;

Re: Why null values stored in variables

Anil_Babu_Samineni — Sat, 12 Aug 2017 00:53:23 GMT

May bebe for thatthat field index value you dont have data so then null produced. Check that.

Re: Why null values stored in variables

sunny_talwar — Sat, 12 Aug 2017 02:42:53 GMT

Because IN has only one value HR, so FieldValue('IN', 2) and FieldValue('IN', 3) and FieldValue('IN', 4) are all null. Out has two values, so 3 and 4 are null... FieldValue looks at the distinct value within a field and that's why 2, 3, 4 for IN doesn't show anything

Re: Why null values stored in variables

vengadeshpalani — Sat, 12 Aug 2017 11:23:36 GMT

I want to show related value instead of null value means what I want to change in script

Re: Why null values stored in variables

sunny_talwar — Sat, 12 Aug 2017 12:13:25 GMT

Use Peek()

LOAD VarCustomer,

IN,

OUT

FROM [test2.xls]

(biff, embedded labels, table is Sheet1$);

let noRows = NoOfRows('A');

TRACE '$(noRows)';

for i=0 to $(noRows)-1

TRACE '----------------------------------------------';

TRACE '$(i)';

let vVar= Peek('VarCustomer',$(i)) ;

let vOriginFormat = Peek('IN',$(i));

let vDestinationFormat = Peek('OUT',$(i));

TRACE '$(vVar)';

TRACE '$(vOriginFormat)';

TRACE '$(vDestinationFormat)';

next i

EXIT SCRIPT;

Re: Why null values stored in variables

Anonymous — Mon, 14 Aug 2017 14:45:36 GMT

Sunny,

Please find this attached QVW file. I'm having the same null values issue, but I've used Peek function only. Kindly help.