Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Soft Coding the Date in the Title

Hi guys,

I have a bar chat with dimensions for "Month" (Jan, Feb, Mar, etc).

I would like to soft code the title to say: "Revenue (Current Month)"

Ex: "Revenue (June)"

And have it continuously update depending on the current month.

Is it possible to soft code it so it correlates with the data being shown?

Thanks for your help.

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

Re: Soft Coding the Date in the Title

Assuming that the month is "closed" when you move to the next month, you can use

month(monthend(reloadtime(),-1))

10 Replies
Not applicable

Re: Soft Coding the Date in the Title

Hello,

Try:  'Revenue (' & Month

Bye,

Estela

mov
Esteemed Contributor III

Re: Soft Coding the Date in the Title

If I got the request right, it'll rather be

='Revenue (' & month(ReloadTime()) & ')'

Not applicable

Re: Soft Coding the Date in the Title

Where does this pull from? Is it pulling the actual current month? I actually want to pull it from the "Month" dimension from my data (which actually has May).

mov
Esteemed Contributor III

Re: Soft Coding the Date in the Title

It's quite a different question.

ReloadTime() is a timestamp of the end of the last successful reload.  If it was in May, it returns May.

MVP
MVP

Re: Soft Coding the Date in the Title

maybe

='Revenue (' & date(max(Month), 'MMM') & ')'

Not applicable

Re: Soft Coding the Date in the Title

Hmm, for some reason this only returns

Revenue ()

With nothing inside the (). Month is a dimension though...

mov
Esteemed Contributor III

Re: Soft Coding the Date in the Title

Probably you have it as text.

What's wrong with the last reload time?  How you decide that it should be May in your case?

Not applicable

Re: Soft Coding the Date in the Title

I'm running a dashboard that shows the latest closed month (in this case, it's May since June hasn't closed yet).

mov
Esteemed Contributor III

Re: Soft Coding the Date in the Title

Assuming that the month is "closed" when you move to the next month, you can use

month(monthend(reloadtime(),-1))

Community Browser