Sales within a date range

[donald_desko]

Hi all,

I'm playing with some play data to see if I can create the following table and attribute an ID for each specific period.
E.g, I have sales data where I can see the quantities sold on each date, for example, 29/06/2020 in this.
This falls inside of period P01, however, how can I allocate the key of 'Period' when it falls within a specifed range.

E.g, any sale made between 29/06/2020 -> 19/07/2020 would have 'P01' as the period column and so on?
I have attached some dummy data.

Thanks,

Don

[Digvijay_Singh]

Probably you are looking for interval match, try following this link from Henric- 

https://community.qlik.com/t5/Qlik-Design-Blog/IntervalMatch/ba-p/1464547