Variable and Trigger Help

Anonymous — Fri, 30 Jan 2015 16:06:23 GMT

I would like my dashboard to open based on the current CLOSE MONTH- which spans the end of the month and the first 13 days of the next month( ie: Jan Close = Jan 28th - Feb 13th). The issue is when the current month changes, the CLOSE MONTH changes to equal the current month(Current Month=Feb & CLOSE MONTH=Feb) when I need it to show( Current Month=Feb, CLOSE MONTH=Jan).

I have set up a Variable(vCurrentFM =Month(Today())) and set the Sheet Trigger to SELECT IN FIELD, Field=[Close Month], Search String=$(vCurrentFM). This works just fine when the CLOSE MONTH and the Current Month are the same. When the Current Month changes to FEB, the CLOSE MONTH still needs to be Jan.

We also go by Work Day(WD) where the minus Work Days(-WD3) is the end of the current CLOSE MONTH and the positive(WD1) is the next calendar month.

I also have an Excel spreadsheet with dates in Column A, Work Day in Column B and Close Month in Column C. I have loaded this spreadsheet into my dashboard, so the CLOSE CALENDAR table has fields = WD, Date, Related Close Month.

Excel format

Date	WD	Month
Wednesday, January 28, 2015	WD-3	Jan
Thursday, January 29, 2015	WD-2	Jan
Friday, January 30, 2015	WD-1	Jan
Sunday, February 01, 2015	SUN	Jan
Monday, February 02, 2015	WD1	Jan
Tuesday, February 03, 2015	WD2	Jan
Wednesday, February 04, 2015	WD3	Jan
Thursday, February 05, 2015	WD4	Jan
Friday, February 06, 2015	WD5	Jan
Saturday, February 07, 2015	WD5(Weekend)	Jan
Sunday, February 08, 2015	WD5(Weekend)	Jan
Monday, February 09, 2015	WD6	Jan
Tuesday, February 10, 2015	WD7	Jan
Wednesday, February 11, 2015	WD8	Jan
Thursday, February 12, 2015	WD9	Jan
Friday, February 13, 2015	WD10	Jan

Is there a different Variable that I can use or can the Excel spreadsheet be used to check the current date and apply the Work Day and the related close month?

Table: Row

Field Names =

[CLOSE MONTH]

Table CloseCalendar:

Field Names=

Date

[Related Close Month]

Any help is greatly appreciated!

topic Variable and Trigger Help in QlikView

Variable and Trigger Help