topic Re: set in QlikView

set

alis2063 — Tue, 22 Nov 2016 15:44:32 GMT

Words Length from string:

How we get the length of word from the string.i.e

i have string as below,

> this is a car.

so i am expecting the result as 4 2 1 3

thanks in Advanced .

swuehl — Tue, 22 Nov 2016 16:33:24 GMT

Maybe something along this (INLINE table is only for demonstration, use your table source instead):

LOAD string, CONCAT(numChar,' ',index) as numChars

GROUP BY string;

LOAD *, LEN(word) as numChar;

LOAD *, SUBFIELD(string,' ',iterno()) as word, iterno() as index

INLINE [

string

this is a car

]

WHILE iterno() <= SUBSTRINGCOUNT(string, ' ')+1;

string	numChars
this is a car	4 2 1 3

Gysbert_Wassenaar — Tue, 22 Nov 2016 16:55:24 GMT

and if you want a chart expression:

=$(=concat( 'Len(Subfield(''this is a car'','' '',' & ValueLoop(1, SubStringCount('this is a car',' ')+1) & '))' , ' & '' '' & '))

sillytricksdepartment‌

alis2063 — Wed, 23 Nov 2016 13:50:00 GMT

can we use it as variable for column in qlikview ui.