topic Re: Using Qlikview, Issue with Len Function in QlikView

Using Qlikview, Issue with Len Function

Anonymous — Thu, 18 Oct 2018 12:30:51 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 !! 🙂

MarcoWedel — Thu, 18 Oct 2018 19:06:46 GMT

Let chknbr = len(chknbr1);

hope this helps

regards

Marco

MarcoWedel — Thu, 18 Oct 2018 19:10:59 GMT

please don't create multiple threads for the same question:

thanks

regard

Marco

vvira1316 — Thu, 18 Oct 2018 19:11:24 GMT

Set chknbr1 = 'D330836','D329537';
Let chknbr = len(chknbr1);

Not sure what is your expected output but above will give chknbr = 19

MarcoWedel — Thu, 18 Oct 2018 19:16:14 GMT

hope this helps

regards

Marco