I have a consolidated fact table with data concatenated from 2 different fact tables F1 (Sales value) and F2 (Total Sales Value) in my Qlikview model. The data is coming at different Product level (F1 - Product, F2 - Product Group)
My requirement is as follows,
1. Users will select a date range and product
2. The Qlikview report has to get the total sales value (from F2) for the outlets which has sold the selected product at least once over the selected date range.
I am facing issues in getting the 'Total sales' from F2 for the outlets which has 'Sales' (from F1) for the selected product. I tried using set analysis but could not pass the list of outlets from F1 data into the F2 data. I am stuck in getting the outlets from F1 and passing them into the F2 to get the total sales value.
I have Flags to identify the source Fact table.
I am sure any of you might have come across this already and throw some light on this issue.
Thanks,
Haneesh
