Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Add text to lable

I am presenting data by quarter, with the labels generated by formula.  I would like to add text after it displays the quarter. Here is one of the labels:

=(QuarterName (SetDateYear (Today(), max (total Year (listed))), 0))

This displays the current quarter, but I would like to add the text 'Listings' after it. Can anyone help?

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Add text to lable

=(QuarterName (SetDateYear (Today(), max (total Year (listed))), 0)) & ' listings'

4 Replies
Not applicable

Add text to lable

Hi,

Try you made a table box whit only field listed?. i think that would be good.

MVP & Luminary
MVP & Luminary

Add text to lable

=(QuarterName (SetDateYear (Today(), max (total Year (listed))), 0)) & ' listings'

Not applicable

Add text to lable

Thanks. How can I format QuarterName to show 1Q12, instead of Jan-Mar 2012?

MVP & Luminary
MVP & Luminary

Re: Add text to lable

Hi,

Try this

=Ceil(Month(Today())/4) & 'Q' & Right(Year(Today()), 2)

Regards,

Jagan.