topic Re: How to show Current month on activate sheet in QlikView

How to show Current month on activate sheet

helen_pip — Tue, 24 Sep 2013 14:30:42 GMT

Hello

I have a field called MonthYear and the data is displayed in MM-YYYY format I.e. Apr-12, May-12 etc

What I would like is for the maximum MonthYear that is available to show when the sheet is activated

Could someone kindly help me with what I should write. I assume that i need the select In Field option on the triggers for sheet properties? but am unsure on what to write

Kind Regards

Helen

Re: How to show Current month on activate sheet

tresB — Tue, 24 Sep 2013 14:37:47 GMT

Have you tried expression: =Max(MonthYear) , in search string?

Well, possibly you are unsure about the format. If so, and if your MonthYear field is a proper date (numeric), then you can try:

=Date(Max(MonthYear),'MMM-YYYY')

Re: How to show Current month on activate sheet

israrkhan — Tue, 24 Sep 2013 14:42:26 GMT

Hi,

Create a variable, and on sheet activate trigger assign =Max(MonthYear), or maxstring(MonthYear)

and then you can use text object to show The value.

hope it help.

Re: How to show Current month on activate sheet

Tue, 24 Sep 2013 14:43:32 GMT

You need something pretty similar to what I've done.

If selected the current year in my list box MYear.

This is done by adding a trigger to the document settings.

From settings -> document settings -> OnOpen

Choose Add Action

And from Selections choose choose in Field (also have a look at the attachment).

What you need to do is to select Max (MonthYear)

Good luck

Re: How to show Current month on activate sheet

Clever_Anjos — Tue, 24 Sep 2013 15:03:22 GMT

Use as below

Re: How to show Current month on activate sheet

ajmalh — Sat, 05 Aug 2023 00:59:19 GMT

Where can I find the same trigger option in Qlik Sense? I'm also stuck in the similar problem.

I have a field called monthyear and I have to display the current month data in all charts or kpis of a particular sheet when opens.