Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have data below:
And I also have a list of ITEM, and what I want to calculate is :
If I choose B and C, I want to calculate what other ITEM the ID who buy ITEM B and C buy?
In this example, it should output
1 A 2
2 D 1
Do you have any ideas?
Thank you!
Try
sum( {$<ITEM = ITEM >} QTY ) Current Selections
sum( {$<ITEM =- ITEM >} QTY ) Exclude Current Selections
Thanks
Bruno
Try this approach
Start with a blank table | QlikCommunity
Vikas
There could be 2 ways to solve your problem:
1. Show/Hide the table chart based on the current selection count (you can use GetFieldSelections to find that)
2. Have a calculated dimension based on GetFieldSelections, which would return a NULL when no selections are made, and 'Suppress when Value is Null' option selected for the dimension
Please go through 2 approach.
Vikas
Try
sum( {$<ITEM = ITEM >} QTY ) Current Selections
sum( {$<ITEM =- ITEM >} QTY ) Exclude Current Selections
Thanks
Bruno