Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Ashok
Contributor III
Contributor III

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

Ashok
Contributor III
Contributor III
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.

Ashok
Contributor III
Contributor III
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

Ashok
Contributor III
Contributor III
Author

Thanks for you suggestion Arjun!!

qlikviewwizard
Master II
Master II

Happy to help you.

Please Mark Correct Answer and close the thread.

View solution in original post