topic Re: For loop issue in QlikView

For loop issue

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Objective is i have 2 columns:

TaskName Comments

a b c qwerty

a b c asdfgh

a b c zxcvbn

desired result is below:

TaskName Comments

a b c qwerty

asdfgh

zxcvbn

for this i am using For loop in script and comparing 2 variables by using If statement like below:

if $(a) = $(b) ;

the values in the variables is as below:

If a b c = a b c

Now i get Script line error due to spacing. How to overcome this problem?

thanks in advance

Sukhwant

Re: For loop issue

sunny_talwar — Thu, 20 Oct 2016 15:16:08 GMT

Why don't you try with Previous/Peek?

Table:

LOAD TaskName,

Comments

FROM Source;

FinalTable:

NoConcatenate

LOAD If(Previous(TaskName) <> TaskName, TaskName) as TaskName,

Comments

Resident Table;

DROP Table Table;

Re: For loop issue

rupamjyotidas — Thu, 20 Oct 2016 15:17:06 GMT

Define your variable as PurgeChar('Taskname',' ')

Re: For loop issue

Thu, 20 Oct 2016 15:35:10 GMT

yes it removed the spaces, but still it is giving same Syntax line error:

If abc = abc

thanks

Re: For loop issue

rupamjyotidas — Thu, 20 Oct 2016 15:40:19 GMT

Can you provide the whole for loop statement you have written. Although what stalwar1‌ has suggested should work for you.

Re: For loop issue

Thu, 20 Oct 2016 15:46:35 GMT

comments:

NoConcatenate

load

Distinct PurgeChar([Task Name],' ') as ctn

from capacity.qvd (qvd)

where Daterecord = '$(vtoday)' and Status = 'WIP';

comments1:

NoConcatenate

load

Distinct ctn

Resident comments;

drop Table comments;

commentstest:

NoConcatenate

load

Distinct PurgeChar([Task Name],' ') as tn,

Comments as c,

Daterecord as dr

from capacity.qvd (qvd)

where Daterecord >= '$(vlastrundate)' and Status = 'WIP';

commentstest1:

NoConcatenate

load

Distinct tn,

resident commentstest

order by tn asc, dr desc;

drop table commentstest;

let i=0;

let comm='';

FOR i=1 to NoOfRows ('comments1')-1

let tn = FieldValue('ctn',$(i));

let j=0;

For j = 1 to NoOfRows ('commentstest1')-1

let tn1 = FieldValue('tn',$(i));

if $(tn) = $(tn1) ;

let comm = $(comm) + FieldValue('c',$(i));

TRACE $(comm);

ENDIF

Not sure Sunny's suggestion will work for me in my future needs as i want to store Text values of Comments column in one variable with the original format ( which includes spaces)

Re: For loop issue

Anil_Babu_Samineni — Thu, 20 Oct 2016 15:52:40 GMT

Can you post that error. Which typo error you are facing over there.

Re: For loop issue

el_aprendiz111 — Thu, 20 Oct 2016 15:53:16 GMT

Hi,

tbl:

LOAD * Inline

[

TaskName,Comments

a b c ,qwerty

a b c ,asdfgh

a b c ,zxcvbn

];

NoConcatenate

SUMARY:

LOAD

TaskName,

IF(Peek('TaskName')=TaskName,'',TaskName) AS TaskNam,

Comments

Resident tbl;

DROP Table tbl;

Re: For loop issue

Oleg_Troyansky — Thu, 20 Oct 2016 15:57:20 GMT

The error is caused by the use of the $-sign expansion for a textual field without single quotes. THe correct syntax is this:

IF '$(a)'= '$(b)' THEN ...

Cheers,

Oleg Troyansky

Learn advanced Qlik techniques in my book QlikView Your Business.