Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Tags (2)
4 Replies
chooco_co
Valued Contributor

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

Hi Siew

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

Regards,

Marco

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

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

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

Hi.

Sorry for the late reply.

Thanks for your reply. It's been helpful.

Not applicable

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

Hi.

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