Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
I have 2 data tables that look something like the below:
Sales table
Year | Month | Day | Product Type | Model | Sale |
---|---|---|---|---|---|
2016 | Jan | 1 | Refridgerator | R1A | 10 |
Washing Machine | WM1 | 2 | |||
TV | TV2 | 5 | |||
2 | Refrigerator | R2B | 5 | ||
R1A | 3 | ||||
Washing Machine | WM2 | 3 | |||
TV | TV2 | 10 | |||
Fan | F3 | 4 |
Countries where products are sold:
Country | Product Type | Model | Product Desc |
---|---|---|---|
Australia | Washing Machine | WM1 | ... |
WM3 | ... | ||
TV | TV1 | ... | |
TV2 | |||
Refridgerator | R2A | ||
Singapore | Washing Machine | WM1 | |
WM2 | |||
TV | TV3 | ||
Fan | F3 |
I have to produce a table visualisation that will display the product type, product model and the description that sells the most based on filters by year, month, day and/or country.
May I know how this can be done? I tried to combine the above 2 tables by doing a join and performing a count at the load script and performing a count but I realized that if i do it, my count won't change if I perform a filter.
Would appreciate it very much if someone can advice me how to go about computing for this visualization.
Thank you and Regards,
Siew Peng
Hi Siew
I tried to understand your question so i create an excel file as my data and create qlik sense apps.
Regards,
Marco
Hi,
Check this attached Qlik Sense Application which i developed for you on the basis of your data provided. With a new data model with single key to get product desc and with some charts.
Regards
Anand
Hi.
Sorry for the late reply.
Thanks for your reply. It's been helpful.
Hi.
Thanks for your reply. I've tried it out and it's been helpful.