Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
krishna20
Specialist II
Specialist II

Calendar Object

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

1 Solution

Accepted Solutions
Siva_Sankar
Master II
Master II

Hi Krishna,

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

View solution in original post

7 Replies
greeshma_k
Creator III
Creator III

Hi,

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

Regards,

Greeshma

qlikviewwizard
Master II
Master II

krishna20,

Try As greeshma_k said.

krishna20
Specialist II
Specialist II
Author

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
Master II
Master II

Hi Krishna,

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

View solution in original post

greeshma_k
Creator III
Creator III

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

greeshma_k
Creator III
Creator III

Hi,

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

Regards,

Greeshma

krishna20
Specialist II
Specialist II
Author

Thank you Greeshma and Siva Sankar.