topic Re: for loop to set variable from field value in QlikView

for loop to set variable from field value

vengadeshpalani — Wed, 25 Nov 2020 16:16:04 GMT

hi all

I want to set variable by using For Loop based on Customer field from Source Table,

Source:

LOAD Customer,

Product

FROM (ooxml, embedded labels, table is Sheet1);

for loop starting here for every customer

selectedcustomer:

LOAD Customer as selectedcustomer,

Product

Resident Source Where Customer = ' Dynamically Change Customer Variable';

ExcludeCustomer:

LOAD Customer as ExcludeCustomer,

Product

Resident Source Where Customer <> 'Dynamically Change Customer Variable';

Re: for loop to set variable from field value

Anil_Babu_Samineni — Mon, 07 Aug 2017 15:59:48 GMT

you are taking Variable and same time you are joining to each table and excluding the same variable. I am not sure i followed you

Re: for loop to set variable from field value

effinty2112 — Mon, 07 Aug 2017 16:11:25 GMT

Hi Vengadesh,

Instead of all that looping why not:

Mappingselected:

Mapping

LOAD

Autonumber(Customer & '|' & Product,'SelectedID'),

'Selected Customer'

FROM

Test.xlsx

(ooxml, embedded labels);

Cross:

Load

Distinct

Customer

FROM

Test.xlsx

(ooxml, embedded labels);

Outer Join(Cross)

Load

Distinct

Product

FROM

Test.xlsx

(ooxml, embedded labels);

Final:

Load

ApplyMap('Mappingselected',Autonumber(Customer & '|' & Product,'SelectedID'),'Excluded Customer') as Status,

Resident Cross;

Drop table Cross;

Product	Customer	C1	C2	C3	C4
A		Selected Customer	Selected Customer	Selected Customer	Excluded Customer
B		Selected Customer	Selected Customer	Selected Customer	Excluded Customer
C		Selected Customer	Selected Customer	Excluded Customer	Excluded Customer
D		Selected Customer	Selected Customer	Excluded Customer	Excluded Customer
E		Selected Customer	Excluded Customer	Excluded Customer	Excluded Customer
F		Selected Customer	Excluded Customer	Excluded Customer	Excluded Customer
G		Selected Customer	Excluded Customer	Excluded Customer	Selected Customer
H		Selected Customer	Excluded Customer	Excluded Customer	Selected Customer
I		Selected Customer	Excluded Customer	Excluded Customer	Excluded Customer
J		Excluded Customer	Selected Customer	Selected Customer	Excluded Customer
K		Excluded Customer	Selected Customer	Excluded Customer	Selected Customer
L		Excluded Customer	Excluded Customer	Excluded Customer	Selected Customer
M		Excluded Customer	Excluded Customer	Excluded Customer	Selected Customer
O		Excluded Customer	Excluded Customer	Selected Customer	Excluded Customer
Z		Excluded Customer	Excluded Customer	Excluded Customer	Selected Customer

Regards

Andrew

Re: for loop to set variable from field value

vengadeshpalani — Mon, 07 Aug 2017 16:28:34 GMT

Ok Anil

I removed join

My question is i have field Customer by using customer i want to perform some action for every customer so i want to add for loop

Re: for loop to set variable from field value

marcus_malinow — Tue, 08 Aug 2017 08:44:21 GMT

Hi vengadesh,

it's not clear what result you are expecting.

Instead of describing the solution (which you are obviously struggling with, hence posting on here), why don't you illustrate the output you are looking for.

Marcus