topic Re: Qlikview :- Using Len function and getting an error/Null values in QlikView

Qlikview :- Using Len function and getting an error/Null values

Anonymous — Thu, 18 Oct 2018 11:31:06 GMT

I have the following line of codes in the load script :-

Set chknbr1 = 'D330836','D329537';

Let chknbr = len($(chknbr1));

Then, I am getting chknbr <NULL>

If I write like the following :-

Set chknbr1 = 'D330836','D329537';

Let chknbr = len('$(chknbr1)');

Then I am getting the following error :-

Script line error:

Let chknbr = len('''D330836'',''D329537''')

Any help would be highly appreciated !! 🙂

Anonymous — Thu, 18 Oct 2018 19:06:07 GMT

Try this

Set chknbr1 = ''D330836','D329537'';

Let chknbr = len((chknbr1));

MarcoWedel — Thu, 18 Oct 2018 19:09:53 GMT