topic Re: How to show the max(Date) for a Calendar Object when we click ClearAll in QlikView

How to show the max(Date) for a Calendar Object when we click ClearAll

nikhilgarg — Mon, 15 Jun 2015 12:30:09 GMT

Hey,

I want to show the max(Date) for a Calendar Object when we click ClearAll. IS ther eany way out for this?

Thanks

Re: How to show the max(Date) for a Calendar Object when we click ClearAll

m_woolf — Mon, 15 Jun 2015 13:48:43 GMT

You can probably do this with a trigger on the Date field.

Re: How to show the max(Date) for a Calendar Object when we click ClearAll

ajaykumar1 — Mon, 15 Jun 2015 13:51:46 GMT

Hi Nikhil,

One way is : You can lock this field after setting the option in triggers as select in field---max(Date) in the sheets wherever you required.

Regards,

Ajay

Re: How to show the max(Date) for a Calendar Object when we click ClearAll

nikhilgarg — Mon, 15 Jun 2015 13:57:47 GMT

I have applied trigger on activate sheet , for date it will select max(date) when sheet is activated. But dont know how to apply trigger when clear all is clicked. IS it possible ?

Re: How to show the max(Date) for a Calendar Object when we click ClearAll

sorrakis01 — Mon, 15 Jun 2015 14:01:29 GMT

Hi,

First disable your clear all buttons (except toolbar, I think you can only disable it with Ajax but I don't Know it exactly)

Secondly You can create a button for clear all and after select the max value (using the action triggers of the object).

or try this:

https://community.qlik.com/message/752713#752713

Regards,

Re: How to show the max(Date) for a Calendar Object when we click ClearAll

m_woolf — Mon, 15 Jun 2015 14:03:40 GMT

Re: Macro after clear all

Re: How to show the max(Date) for a Calendar Object when we click ClearAll

Anonymous — Mon, 15 Jun 2015 14:36:19 GMT

Hi,

Maybe this help you.

Regards.

Jannet.

Re: How to show the max(Date) for a Calendar Object when we click ClearAll

Qlikandlearn — Mon, 12 Oct 2020 16:14:45 GMT

HI, I've the same requirement, I did the same way specified above, when I opened the qvw, it selects the max(Date), but when I select different date and click on clear, still it's showing the date other than Max date.

Example: one of my other report has same way, it has select field and clear all triggers, when I open the report, it's filtered on max period, if I select any different date then the report will filter on that selected date, but When I clicked on the clear button, it automatically jumps to the triggered selection of Max(date), don't know how it is jumping, Experts any idea?