topic Show the current month in Calendar Object in QlikView

Show the current month in Calendar Object

Thu, 28 Aug 2014 13:11:47 GMT

Hi, people.

I have a calendar object that ranged from jan/1/2013 to dec/31/2015.

Now, I need show at first moment, without any filter, the current month.

Repeat: I don't have selections, yet, and I need the calendar object show the current month, not the first month in the list of possibles dates.

How can I achieve this view in that object?

Thanks so much.

Have you a nice day work.

...

Ricardo Ildefonso

Re: Show the current month in Calendar Object

Anonymous — Thu, 28 Aug 2014 13:23:52 GMT

try the calendar object using a variable:

define a new variable: vDate = date(max(yourdate))

and in your calendar object define the variable vDate and it should show the latest date

( I tested with day date, but should also work with months)

Re: Show the current month in Calendar Object

Fri, 29 Aug 2014 12:20:50 GMT

Thanks, Rudolf.

My calendar is linked to a table, because my invoices are also.

Than, if I set a variable to the calendar, necessarily I will filter my invoices to that date.

It is not a write behavior to application.

This frustrate me, and I think it frustrate all. The calendar must have a way to be set to current month. Just because 90% of case, when we have a calendar, all our tasks start with look arround presente date.

Some one already solve this problem? What do you use?

Again, thanks for your attention.

...

Ricardo Ildefonso