If App reloads in weekday, the data in the app should show upto reload date-3

[karthik_vp]

Hi All,

I have a scenario which client requested is mentioned below. Please help me on this.

I have an application which having 30 days rolling data. (which means it has last 30 days data).

When the application reloads in weekdays, the data should show upto Reload date -3, same if the application reloads in weekend, the data should show till Reload date -4.

For example, if the application reloads on Friday, the data should show till last Tuesday.

Same if the application reloads on Sunday the data should show till last Thursday. 

Can anyone help me on this scenario?

Thanks in Advance!!!

Regards,

Karthik VP

[PrashantSangle]

do you have any date which suggest that data is till what date???

Regards,
Prashant Sangle

[karthik_vp]

Hi Prashant,
Thanks for quick response...
If the app reloads on 03/22/2019(Friday- which is a weekday), the data should show till 03/19/2019 (Tuesday).
Regards,
Karthik VP

[pradosh_thakur · Accepted solution]

weekday function returns 5,6 for saturday and sunday. you can use condition on that to filter the data. 

https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/DateAndTimeFunctions/weekday....

[karthik_vp]

Thanks to all who has responded immediately.... The issue got resolved..... Thanks once again...