Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Skipping days

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

1 Solution

Accepted Solutions
qlikviewwizard
Master II
Master II

Happy to help you.

Please Mark Correct Answer and close the thread.

View solution in original post

7 Replies
qlikviewwizard
Master II
Master II

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?

qlikviewwizard
Master II
Master II

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 ;

1.png

2.png

3.png

4.PNG

5.PNG

Anonymous
Not applicable
Author

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.

Anonymous
Not applicable
Author

Looking forward to your comments!!

qlikviewwizard
Master II
Master II

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 ;

Capture.PNG

Anonymous
Not applicable
Author

Thanks for you suggestion Arjun!!

qlikviewwizard
Master II
Master II

Happy to help you.

Please Mark Correct Answer and close the thread.