Calendar Object

[krishna20]

Hi Friends,

In my dashboard i'm showing last three years in list box, under that showing calendar objects from selecting the data range.

My requirement is in on active sheet max year should select in listbox and in the From calendar, Date(Yearstart(Max(Date_Field))) to be selected and in the To Calendar Date(Addmonths(Max(Date_Field),0)) need to select .

If i select 2014 , the calendar object should change from 01/01.2014 to 31/12/2014 dynamically.

How can we achieve it.Please anyone suggest me. Please find the sample file.

Regards

krishna

[Anonymous]

Hi,

You can set a document trigger. Go to  Document Properties>>Triggers>>Select On open>>Add Action>> Select in Field

Regards,

Greeshma

[qlikviewwizard]

krishna20,

Try As greeshma_k said.

[krishna20]

Hi Greeshma,

Thank you for reply. I have done that for list box selection. I need in the calendar object .It should changes accordingly with the list box's year.

[Siva_Sankar · Accepted solution]

Hi Krishna,

I have changed the variable formula. Check the document now.

[Anonymous]

Hi,

Add a trigger on the year field  and using this set the variables used in the calendar object. I have done this on your  QVW but unable to attach it.

Regards,

Greeshma

[Anonymous]

Hi,

Please see attached. I have added trigger on year field.

Regards,

Greeshma

[krishna20]

Thank you Greeshma and Siva Sankar.