topic Re: Calendar Object in QlikView

Calendar Object

krishna20 — Mon, 11 May 2015 07:10:03 GMT

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

Re: Calendar Object

Anonymous — Mon, 11 May 2015 07:16:32 GMT

Hi,

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

Regards,

Greeshma

Re: Calendar Object

qlikviewwizard — Mon, 11 May 2015 07:21:02 GMT

krishna20,

Try As greeshma_k said.

Re: Calendar Object

krishna20 — Mon, 11 May 2015 07:21:03 GMT

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.

Re: Calendar Object

Siva_Sankar — Mon, 11 May 2015 07:23:02 GMT

Hi Krishna,

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

Re: Calendar Object

Anonymous — Mon, 11 May 2015 07:43:11 GMT

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

Re: Calendar Object

Anonymous — Mon, 11 May 2015 07:44:01 GMT

Hi,

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

Regards,

Greeshma

Re: Calendar Object

krishna20 — Mon, 11 May 2015 08:11:40 GMT

Thank you Greeshma and Siva Sankar.