I need a help on dates in period

[suresherks1]

Hi,

I have two charts side by side one chart is showing the daily date range another chart showing the next 7 days date range

for Ex:

if I select the date filter into 1/06/2020, it's showing 1 to 8 days in both charts, if I select 2/06/2020 days in date filter left side chart it shows like 1 to 9 dates on the right chart showing in  2 to 9 days, this report created by PowerBI (they used to date in period function for this ), but I need to covert this report into Qliksense, how can I do the same exact logic in Qliksense, can anyone guide me.

Thanks 

Suresh

[sunny_talwar]

You can do this using set analysis. But to get precise help, would you be able to provide some sample data?

[suresherks1]

Thanks for replying Talwar,

This data comes from different sheets, those are in below