Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Using Qlikview, Issue with Len Function

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 !! 🙂

4 Replies
MarcoWedel

Let chknbr = len(chknbr1);



hope this helps


regards


Marco

MarcoWedel

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

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

thanks

regard

Marco

vvira1316
Specialist II
Specialist II

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

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

MarcoWedel

QlikCommunity_Thread_317245_Pic1.JPG

hope this helps

regards

Marco