Hello,
I am trying to get an intersection of Value_keys from the attached qvw. It works fine when i restrict it to one customer but i am not sure how i can dynamically pass every customer into the calculation.
I have attached the qlikview file with the working calculation and the table where it breaks.
I have also attached the excel file source along with a tab which has an example of the intersection. I preferably want to do this in the UI but open to other solutions.
Any help is appreciated.
Thanks,
Sri