topic Load Script to show only the values as per selection in QlikView

Load Script to show only the values as per selection

vikasshana — Tue, 23 Aug 2022 13:30:45 GMT

Hi,

I've below sample data from different data sets.

Tab1:
Load * Inline
[
ID, Code
1, AB
2, AC
];

Tab2:
Load * Inline
[
ID, QV
1, NFA
1, NFB
2, NFC
2, NFD
];

Tab3:
Load * Inline
[
QV, Sale, Code1
NFA, 100, AA
NFB, 200, AB
NFC, 300, AC
NFD, 400, AD
];

Exit Script;

After loading, in the front end I created filters for ID and Code, If I select ID as 1 then code AB is activated. Now my requirement is if I select ID as 1 then code AB has to be activated along with that QV has to display NFB and Sales has to display 200 and Code1 has to display AB only.

Regards,

Barat Vikas

@PrashantSangle

Re: Load Script to show only the values as per selection

BrunPierre — Tue, 23 Aug 2022 23:43:45 GMT

Have a go at this remodelled script syntax

MergedTable:
LOAD QV, Sale, Code1 as Code,Code1
RESIDENT Tab3;

LEFT JOIN(MergedTable)
LOAD ID, Code
RESIDENT Tab1;

LEFT JOIN(MergedTable)
LOAD ID, QV
RESIDENT Tab2;

DROP TABLE Tab3,Tab1,Tab2;

EXIT SCRIPT;

Output

Re: Load Script to show only the values as per selection

sidhiq91 — Wed, 24 Aug 2022 03:12:13 GMT

@vikasshana Please follow the below script:

NoConcatenate
Temp:
Load QV, Sale, Code1 as Code, Code1
Inline
[
QV, Sale, Code1
NFA, 100, AA
NFB, 200, AB
NFC, 300, AC
NFD, 400, AD
];

left join (Temp)

Load * inline [
ID, Code
1, AB
2, AC
];

left join (Temp)

Load * Inline
[
ID, QV
1, NFA
1, NFB
2, NFC
2, NFD
];

exit Script;

If this resolves the issue please like and accept it as a solution.