Using two calendars

Fri, 25 Nov 2011 08:09:41 GMT

Hi,

We have Standard and Fiscal calendar in our application. Based on the user's selection, listbox and chart will display the selected calendar attributes.

Say for example we have CalendarYear, CalendarQuarter, FiscalYear, FiscalQuarter in the table. Using a button user can select either Standard or Fiscal calendar and the selection will be captured in a variable(vCalendar).

And we have created variables for each calendar attribute like vYear=if(vCalendar='Fiscal','FiscalYear','CalendarYear'). And these variables are used in the listbox and charts.

Now the problem is,

Since user can create their own objects there may be a conflict between the selection on standard and fiscal calendar.

ie) user have selected Fiscal calendar in the button and he has created a Standard CalendarYear listbox and made some selection on standard CalendarYear.

But in the charts we are using the variable which will be changed based on the selection on the button.

In this situation, curent selection will show the Standard CalendarYear whereas charts will show the Fiscal Year.

Is there any possility to eliminate this conflict?

Please share your thoughts....

topic Using two calendars in QlikView

Using two calendars