topic Re: Special Select in QlikView

Special Select

hibhardwaj — Sat, 16 Nov 2024 18:33:12 GMT

Hello,

I have an interesting scenario that I am trying to find a solution to. Maybe it is already been discussed, but I did not find it and so posting here.

Scenario: In the database I have this table of what SKUs are consisted in what Box:

Box	SKU
A	1, 2, 3
B	2, 3, 4
C	3, 4, 5
D	6, 7, 8

Outcome: I should be able to show different Boxes based on my SKU selection.

SKU Selection	Expected Result
1	A
3	A, B, C
1, 2	A, B
6, 7, 8	D

Basically I am looking for a way to select a SKU to show all the combinations of that SKU (Tough to put it in words for me). Hopefully I am explaining that in the example above little more clearly 😛

Appreciate your time.

Thanks,
~Himanhsu

@Miguel

Re: Special Select

rubenmarin — Tue, 02 Jun 2020 14:59:28 GMT

Hi, maybe loading each Box and SKU combination in a difffernt row, so you can selct any value you want and keep the relations of those values.

This can be done with Subfield without 3rd parameter:

LOAD Box, Subfield(SKU, ',') as SKU From/Resident...

For the expected result you can use concat:

Concat(Distinct Box)

Re: Special Select

hibhardwaj — Tue, 02 Jun 2020 15:25:31 GMT

Thanks for your reply. But the question is- which I should have mentioned in the original post- I am trying to avoid to run the query wide open for ALL the Boxes. There may be other BOXes in the database that may have SKUs 12, 13, 14, 15, etc. I am trying to exclude such BOXes that dont contain a single SKU that is needed for analysis.

Let me know if I am not making sense 😞

~Himanshu

Re: Special Select

YJ_SG — Tue, 02 Jun 2020 15:42:39 GMT

Can try rebuild table as following

Box, SKU

A,1

A,2

A,3

B,2

B,3

B,4 ........

Choose 1, show A. Choose 2, show A,B

Re: Special Select

rubenmarin — Wed, 03 Jun 2020 06:34:21 GMT

Hi, I don't have a clear undertanding of what is needed. You are already retrieving all the data you need? Or you want some way to filter the querys to database?