topic Expression in Title in QlikView

Expression in Title

gerhardl — Mon, 18 Apr 2011 10:20:01 GMT

Hi,

Can I put an expression in the Title of a chart?

I have a chart called "Performing Customers for the Month". I would like it to say "Performing Customers for April", with the month name being determined by the expression.

This is the expression I use to determine the number of performing customers, so I could use the variable to determine the "current" month (which is just the maximum month).

COUNT({1<[Effective Year]={$(=($(vCurrentYearPurchase)))},[Effective Month]={$(=($(vCurrentMonthNamePurchase)))},[Tran Code]*={35}>} [Effective Date])

Thanks,

Expression in Title

Mon, 18 Apr 2011 10:34:23 GMT

In Window title

Put in

=COUNT({1<[Effective Year]={$(=($(vCurrentYearPurchase)))},[Effective Month]={$(=($(vCurrentMonthNamePurchase)))},[Tran Code]*={35}>} [Effective Date])

Regards

Anders

Expression in Title

gerhardl — Mon, 18 Apr 2011 11:14:00 GMT

Hi Anders,

I am using =Month($(vCurrentMonthPurchase)) and that works fine, but it just gives me the monththen - April.

I would like the title to be "Performing customers for April", so it must be normal text, and then the expression value.

Possible?

Thanks,

Expression in Title

Mon, 18 Apr 2011 11:22:10 GMT

Use

='Performing customers for ' & Month($(vCurrentMonthPurchase))

Regards

Anders