Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Gowtham174
Creator
Creator

Previous date in the specify data

Hi All,

I have a custom Calendar where we defined specify weekending as show below. Now i need to show in the text box last week date start date and end date. can you please help me with this.

Output:
Start Date - 16-11-2018
End Date - 30-11-2018

WEEK_END
28-09-2018
05-10-2018
12-10-2018
21-10-2018
26-10-2018
02-11-2018
09-11-2018
16-11-2018
21-11-2018
23-11-2018
30-11-2018

Thanks,
Gowtham

3 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Can you help us understand, how did you got the startdate?

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Gowtham174
Creator
Creator
Author

Start date also pulling from excel file where they define week start and end date.

Since user should control the weekending date. basically they month end is 21st of every month and if week end is near to month end they will make weekend as month date.

WEEK_START WEEK_END
22-09-2018 28-09-2018
29-09-2018 05-10-2018
06-10-2018 12-10-2018
13-10-2018 21-10-2018
22-10-2018 26-10-2018
27-10-2018 02-11-2018
03-11-2018 09-11-2018
10-11-2018 16-11-2018
17-11-2018 21-11-2018
22-11-2018 23-11-2018
24-11-2018 30-11-2018 

Gowtham174
Creator
Creator
Author

Can any one help me in this requirement.

Thanks,
Gowtham