topic Re: Loop in in QlikView

Loop in

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

Hello Team,

As a new to Qlikview, need help on the implement the below scenarion.

Need to lookup from the Inline Load and update the values in the Qlikview Table Box (Value to be derived).

Below the example

Table 1		Table2:Inline Load
Lookup	Value to derived	Items	Cost
A	10	A	10
B	20	B	20
C	30	C	30
A	10
B	20
C	30
A	10
B	20
C	30

Re: Loop in

rwunderlich — Fri, 22 Sep 2017 05:13:45 GMT

There should be no loop required. Just load both tables with a field named Item.

QV's associative logic will automatically join the values together.

-Rob

Re: Loop in

its_anandrjs — Fri, 22 Sep 2017 05:26:03 GMT

Try to load this ways and rename field Items to Lookup for association

Table_1:

Load * Inline

[

Lookup, Value to derived

A, 10

B, 20

C, 30

A, 10

B, 20

C, 30

A, 10

B, 20

C, 30

];

Table2:

LOAD Items as Lookup,Cost;

LOAD * Inline

[

Items, Cost

A, 10

B, 20

C, 30

];

Re: Loop in

Anonymous — Fri, 22 Sep 2017 06:01:12 GMT

Thanks verymuch

Re: Loop in

enricohdi2 — Fri, 22 Sep 2017 06:49:12 GMT

UNQUALIFY '*';

Table_1:

Load * Inline

[

order, Lookup, Value_to_derived

1, A, 10

2, B, 20

3, C, 30

4, A, 10

5, B, 20

6, C, 30

7, A, 10

8, B, 20

9, C, 30

];

Table2:

NoConcatenate

LOAD Distinct

Lookup as Items,

Value_to_derived as Cost

Resident Table_1;