topic Re: Load data contains the specific value with ID in QlikView

Load data contains the specific value with ID

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

We required IDs data contains 'Test3', Please refer the sample screenshot below.

LOAD * INLINE [
ID, Name, Category
1, dsfdsgdfg, Test1
1, dsfdsgdfg, Test2
1, dsfdsgdfg, Test3
1, dsfdsgdfg, Test4
2, bffgtr, Test1
2, bffgtr, Test2
3, gfhtrhtr, Test2
3, gfhtrhtr, Test3
3, gfhtrhtr, Test4
4, nghntnry45, Test2
5, gfngfbw56, Test1
5, gfngfbw56, Test2
5, gfngfbw56, Test3
5, gfngfbw56, Test4
6, jkmtyerea, Test2
6, jkmtyerea, Test3
7, hgjtyurty, Test1
7, hgjtyurty, Test2
7, hgjtyurty, Test4
8, kjljtytr, Test1
8, kjljtytr, Test2
8, kjljtytr, Test4
9, yutrytry, Test3
];

Re: Load data contains the specific value with ID

Vegar — Tue, 26 Mar 2019 16:39:06 GMT

Test3IDs:
Load ID as Test3ID from source where category = 'Test 3';

Final:
Load ID, Name, Category
From source
where exists(Test3ID, ID);
Drop table Test3IDs;

Re: Load data contains the specific value with ID

karan_kn — Tue, 26 Mar 2019 17:13:31 GMT

Thanks for the response, but I need output exactly like above screenshot, as I'm getting only Test3 data

Re: Load data contains the specific value with ID

dplr-rn — Tue, 26 Mar 2019 17:30:28 GMT

If you follow vegar's method your datamodel will contain only what you desire as output .
please specify if you want the output only on the UI or the full datamodel.
latter is vegars approach.
if you want the former you can modify vegars code and add a flag on all the ids which has Test3

Re: Load data contains the specific value with ID

karan_kn — Tue, 26 Mar 2019 17:40:24 GMT

I need output only on the UI, I mean Pivot table

Re: Load data contains the specific value with ID

dplr-rn — Tue, 26 Mar 2019 17:54:30 GMT

2 options
1- try something like below to creata a flag and use set analysis like Test3Flag={'Y'} in your pivot table
Test3IDs:
Load ID, 'Y' as Test3Flag from source where category = 'Test 3';
2- Option 2 pure set analysis something like below
Sum( {<
ID=p( {<Category={'Test3'}>}ID)
>}
YourMeasure)