topic Issue with window title in QlikView

Issue with window title

Wed, 10 Feb 2010 10:40:56 GMT

Hi All,

I want to show the below title as the window title.

TOP 10 2008

where 2008 should be fetched using the expression (Max(Year)-1). Let me know how to do that.

I used below one in the expression but it doesn't work. I know it must be very very simple but i don't know here i missed out.

= & ' Top 3 ' & (Max(Year)-1)

Hope some one can help me out!

Regards,

Rikab

Issue with window title

Miguel_Angel_Baeyens — Wed, 10 Feb 2010 10:59:41 GMT

Try

=' Top 3 ' & (Max(Year)-1)

Issue with window title

Wed, 10 Feb 2010 11:04:11 GMT

Hi Miguel!

Thanks for your quick reply. That is working perfectly. In few of my other post i have been waiting these days for your reply. When you get some some time please reply me.

Thanks and Regards,

Rikab

Issue with window title

Wed, 10 Feb 2010 11:07:23 GMT

I think the problem is that 'Year' is not being interpreted as a number. Try forcing it to a number using (Max(num#(Year))-1)

Regards,

Gordon

Issue with window title

Wed, 10 Feb 2010 11:21:47 GMT

Hi,

Not sure about your thought. But the expression sent my Miguel is working. I will check your as soon as possible and will let you know. Thanks for your help.

<pre>=' Top 3 ' & (Max(Year)-1

Regards,

Rikab