Discussion board where members can get started with QlikView.
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?
Go to Solution.
=(QuarterName (SetDateYear (Today(), max (total Year (listed))), 0)) & ' listings'
Try you made a table box whit only field listed?. i think that would be good.
Thanks. How can I format QuarterName to show 1Q12, instead of Jan-Mar 2012?
=Ceil(Month(Today())/4) & 'Q' & Right(Year(Today()), 2)