Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Ashok
New 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
Arjunarao
Honored Contributor II

Re: Skipping days

Happy to help you.

Please Mark Correct Answer and close the thread.

7 Replies
Arjunarao
Honored Contributor II

Re: Skipping days

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?

Arjunarao
Honored Contributor II

Re: Skipping days

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

Re: Skipping days

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

Re: Skipping days

Looking forward to your comments!!

Arjunarao
Honored Contributor II

Re: Skipping days

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

Re: Skipping days

Thanks for you suggestion Arjun!!

Arjunarao
Honored Contributor II

Re: Skipping days

Happy to help you.

Please Mark Correct Answer and close the thread.

Community Browser