Displaying Column Names as Text Instead of Numbers

[#1]

So there could be an easy way to do this, I assumed the text() function could handle it, but when I looked it up on help, it said that the result would come out as " - ".

Anyway, I have a table with 10 rows and say 50 columns. I'm trying to group the columns in 4 categories by size and graph those 4 categories. For example, Each column is a year and I would like to group years <10, 11-15, 16-24, and 24+. Then graph the resulting 4 categories as a stacked bar graph for each row (which also happen to be years).

Here is a picture of my data and dimension formula ungrouped:

I'm using the left() function because the maturityDt field is in yyyymmdd format. So as you can see I'd like to group these years in four categories; since it will make it look cleaner than having about 50 years. Here is a screen shot of what I have grouped:

So as you can see, the 1 column is anything that's 25 years + and the 0 column is everything else. I will probably do an imbedded if() statement that will take care of the 0 column but as far as the 1 column: I would like to know how to display that 1 as text and says ">25 Years" instead of 1, thanks.

[pover · Accepted solution]

Does a if((left(maturityDt,4)-Year)>=25,'>25 Years',0) work?

Regards.

[#3]

I actually tried using " instead of ' which was my mistake, thanks. Simple fix.

[#4]

Another question I had was what is the equivalent of the if(and()) statement in QV script? I want to condition a field to be between 16-24 years...

[pover]

The and() would be

if((left(maturityDt,4)-Year)<25 and (left(maturityDt,4)-Year)>=16 ,'>=16<25 Years',0)

[#6]

Thanks Karl