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

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

karthik_vp — Fri, 22 Mar 2019 08:43:31 GMT

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

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

PrashantSangle — Fri, 22 Mar 2019 09:22:07 GMT

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

Regards,
Prashant Sangle

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

karthik_vp — Fri, 22 Mar 2019 09:56:58 GMT

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

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

pradosh_thakur — Fri, 22 Mar 2019 10:20:14 GMT

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.htm?_ga=2.95095132.1167857519.1553248084-666779635.1553153133

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

karthik_vp — Fri, 22 Mar 2019 13:26:21 GMT

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