Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik Community!
I have a problem which I can't find the solution right now and I have twisted my head around this for some days.
The data I get are in the following pattern:
IITEM NO | CATALOGUE | NUMBER OF SALES
1000 A 1000
1000 B 2000
1000 C 3000
What I need to do is create a table with following function:
ITEM NO | NUMBER OF SALES CATALOGUE SELECTION 1 | NUMBER OF SALES CATALOGUE SELECTION 2
1000 1000 3000
LIST WITH CATALOGUE SELECTION 1:
A (selected in the above example)
B
C
LIST WITH CATALOGUE SELECTION 2:
A
B
C (select in the above example)
The obvious problem is I can't do this via 2 normal filters, because one selection cancels the other out.
I tried different approaches via set analysis but nothing works, because it goes against the functionality of filters.
Anyone got any ideas how to solve this without the use of extensions (we are not allowed to use them cause of maybe discontinuity in the future)?
My only other approach would be to create a new data model with some kind of matrix where every catalogue has every other catalogue corresponding to them in the data, but that would create a lot of data.
Best regards
I understand why you can't use Extensions, you never know when they might stop working and if they will be updated or not.
But this is a typical example of alternate states which, as far as I know, can't be solved without an extension.
I understand why you can't use Extensions, you never know when they might stop working and if they will be updated or not.
But this is a typical example of alternate states which, as far as I know, can't be solved without an extension.
Thanks for the clarification, I feared it would be that way, so I have to solve this via SQL...what a mess.
The only (quick and dirty) solution I can think of right now would be the following:
Test:
Load * Inline [
ITEM NO,CATALOGUE1,NUMBER OF SALES
1000,A,1000
1000,B,2000
1000,C,3000
];
Test2:
Load * Inline [
ITEM NO,CATALOGUE2,NUMBER OF SALES2
1000,A,1000
1000,B,2000
1000,C,3000
];
But this would effectively double your data.
It would allow you to have different selections in the "same" dimension.