topic Re: Loop in QlikView

Loop

Anonymous — Thu, 09 Jan 2014 08:56:50 GMT

I have a table incident_details,

and assigned group a field in it.

I am creating a qvd for open cases, but each should be according to assigned group.

Example, Suppose Assigned group has 5 data values as A,B,C,D,E,

therefore I want to create open case qvds as Open_A.qvd,Open_B.qvd using a for loop.

Please guide me a bit regarding this....

Re: Loop

swuehl — Thu, 09 Jan 2014 09:03:47 GMT

Maybe like

FOR Each Group in 'A','B','C','D','E'

Tmp:

LOAD CaseField1, CaseField2

FROM Table WHERE GroupField = '$(Group)';

Store Tmp into Open_$(Group).qvd (qvd);

drop table Tmp;

Re: Loop

Michiel_QV_Fan — Thu, 09 Jan 2014 09:06:25 GMT

Try this syntax:

for each group in 'A','B','C',etc

group_$(group):

load *

from <your location>

where group = $(group);

store group_$(group) into group_$(group).qvd (qvd);

drop table group_$(group);

This will loop through all values in the for each ......

Re: Loop

Sokkorn — Thu, 09 Jan 2014 09:23:06 GMT

Hi Nitin,

Here concept with example

[Data]:
LOAD * Inline [
ID, AssGrp, Field1
1, A, F1
2, A, F2
3, B, F3];


[tmpCon]:
LOAD Concat(DISTINCT Chr(39)&[AssGrp]&Chr(39),',') As [AssGrpVal] Resident [Data];


Let vAllAssGrp = Peek('AssGrpVal',0,'AssGrp');
DROP Table [tmpCon];


FOR Each vAssGrp in $(vAllAssGrp)
  $(vAssGrp):
  NoConcatenate
  LOAD * Resident [Data] Where [AssGrp]='$(vAssGrp)';
  STORE $(vAssGrp) into [Open_$(vAssGrp).qvd];
  DROP Table $(vAssGrp);
NEXT vAssGrp;


DROP Table [Data];


Let vAllAssGrp = Null();
Let vAssGrp = Null();

Regards,

Sokkorn