Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Rodlibar
Contributor II
Contributor II

Adding Product Season column in a table in the script

I have a table that set Season collections like below:

SeasonLaunch:
Season.          | Date_ini       | Date_end 
Winter_20     | 01/03/2020 l 01/08/2020
Summer_21 | 01/09/2020 | 28/02/2021


SalesTable:
Product       | Sales_Date

 

ProductTable:

Product  

 

I need to classify the products based on their first sales date by adding the ‘SeasonLaunch’ column to the ‘ProductTable’ in the script.example: 

 

Product A, 1o. sale was in 20/05/2019, them SeasonLaunch is:  Winter_19

 

 

Labels (1)
  • SaaS

2 Replies
Or
MVP
MVP

Sounds like textbook IntervalMatch. Have you tried using that?

1) Load the data

2) Find the first sales date for each product (min() with Group By)

3) Intervalmatch

Rodlibar
Contributor II
Contributor II
Author

obrigado. mas pode descrever como fazer isso por aqui?