Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to derive the computation to get the best selling product in my example?

Hi.

I have 2 data tables that look something like the below:

Sales table

YearMonthDayProduct TypeModelSale
2016Jan1RefridgeratorR1A10
Washing MachineWM12
TVTV25
2RefrigeratorR2B5
R1A3
Washing MachineWM23
TVTV210
FanF34

Countries where products are sold:

CountryProduct TypeModelProduct Desc
AustraliaWashing MachineWM1...
WM3...
TVTV1...
TV2
RefridgeratorR2A
SingaporeWashing MachineWM1
WM2
TVTV3
FanF3

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

4 Replies
marcohadiyanto
Partner - Specialist
Partner - Specialist

Hi Siew

I tried to understand your question so i create an excel file as my data and create qlik sense apps.

Regards,

Marco

its_anandrjs

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

Not applicable
Author

Hi.

Sorry for the late reply.

Thanks for your reply. It's been helpful.

Not applicable
Author

Hi.

Thanks for your reply. I've tried it out and it's been helpful.