This content has been marked as final. Show 3 replies
There are five stores with their sales, and everyone of these is identified by a code. Two of these stores changed their codes two times. In Qlik I have the sum of sales for everyone of this five stores depending on their codes: this means that if the store changed codes three times, in Qlik I see the sum of sales for each of these codes (note that the store is always the same). So, I visualize nine stores.
My target is to visualize only the five stores, and get the aggregate of sales for the two stores that changed code.
Here's an example:
Store A, before having the code 'A', had the code 'F' and 'G'. F made sales for 50, G made sales for 40.
Store B, before having the code 'B', had the code 'H' and 'I'. H made sales for 30, 'I made sales for 20.
The final result is:
How can I do this?