Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have 2 tables:
1. Customer table
2. Products table
In my customer table i have a customer id column and a date column wich show when the customer enter the store and when he exit (customer id + date enter is my unique key)
In my my products table i have the customer id column, product_bought and the date they bought each product.
I want the create association between this 2 table based on the customer id + date_enter +date_bought)
So i will see on each customer what products he bought on each visit on my store.
On sql its going like this:
Join...
On customer id = customer id
And date_bought >= date_enter
And date_bought <= date_exit
Is ther a way to use the same logic on qlik sense also?
Thanks alot!
Sounds like you might be looking for IntervalMatch()
https://community.qlik.com/t5/Design/IntervalMatch/ba-p/1464547
Sounds like you might be looking for IntervalMatch()
https://community.qlik.com/t5/Design/IntervalMatch/ba-p/1464547