topic Re: Skipping days in QlikView

Skipping days

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi team,

I was handling the task as following scenario,

The Dashboard is getting refreshed on all 4 tabs present in the dashboard on every Monday, Now if the month 1st day is an Monday every 4 tabs should get refreshed but month 1st day is not an Monday one particular tab should get skipped.

Please suggest your ideas.

Thanks & Regards,

Ashok Ravichandran

Re: Skipping days

qlikviewwizard — Wed, 11 Jul 2018 04:26:00 GMT

Hi Can you give Yes or No to below questions?

Do you want to refresh 4 tabs on every Monday?

Do you want to refresh 4 tabs if first day is Monday?

Do you want to SKIP 4 tabs to refresh if Day is not Monday?

Do you want to SKIP 4 tabs to refresh if Day is not Monday on first day of the Month?

Re: Skipping days

qlikviewwizard — Wed, 11 Jul 2018 04:42:44 GMT

Hi Try like this:

SET vMonthStartDay=WeekDay(Monthstart(today()));

SET vWeekStartDay=WeekDay(Weekstart(today()));

If $(vMonthStartDay)='Mon' or $(vWeekStartDay)='Mon' THEN

Tab1:

Load * inline [

A,S

1,2

];

elseif ;

Re: Skipping days

Anonymous — Wed, 11 Jul 2018 14:17:02 GMT

Hi Arjun, Thanks for your comments.

Do you want to refresh 4 tabs on every Monday? Yes

Do you want to refresh 4 tabs if first day is Monday? Yes

Do you want to SKIP 4 tabs to refresh if Day is not Monday? only one particular tab should get skiped. Eg: 3rd tab

Do you want to SKIP 4 tabs to refresh if Day is not Monday on first day of the Month? if month 1st day is Wednesday except 3rd tab every should get refreshed, but month first day is also Monday again every 4 tabs should get refreshed.

Re: Skipping days

Anonymous — Wed, 11 Jul 2018 16:51:45 GMT

Looking forward to your comments!!

Re: Skipping days

qlikviewwizard — Thu, 12 Jul 2018 01:25:56 GMT

Hi Ashok,

Use this code in third tab. No need to change the code in other tabs.This will work all.

If ( $(vMonthStartDay)='Mon' or $(vWeekStartDay)='Mon' ) AND ( $(vMonthStartDay)='Wed' or $(vWeekStartDay)='Wed' ) THEN

Tab3:

Load * inline [

A,S

1,2

];

elseif ;

Re: Skipping days

Anonymous — Thu, 12 Jul 2018 12:08:27 GMT

Thanks for you suggestion Arjun!!

Re: Skipping days

qlikviewwizard — Thu, 12 Jul 2018 12:21:26 GMT

Happy to help you.

Please Mark Correct Answer and close the thread.