topic Need to display the year selected in QlikView

Need to display the year selected

raghavsurya — Fri, 02 Jul 2010 06:25:56 GMT

Hi All,

We are currently using a Guage chart to depict the % Sales achieved in current year against previous year. The expression is given as

num(((Sum({<Year={$(=Max(Year))}>} AAmount )))) for the current year. The user wants one box next to the Sales Value to depict the Year to which the amount belongs to. He is not comfortable with the current selected box. Can anyone suggest a work around so that the Year gets displayed against the Sales amount.

Thanks and Regards,

Raghav

Need to display the year selected

Miguel_Angel_Baeyens — Fri, 02 Jul 2010 07:36:07 GMT

Hello Raghav,

You may use a text box with

=Max(Year)

or you can add this same text into your gauge chart by changing your expression name to the code above, showing it as title in the chart...

Need to display the year selected

Fri, 02 Jul 2010 07:44:15 GMT

As above.

I use the text box option because it allows you to customise the output. Also can serve as a handy data validation tool during development.

Need to display the year selected

raghavsurya — Fri, 02 Jul 2010 09:14:48 GMT

Hi Miguel,

Thanks a lot for your suggestion.

Regards,

Raghav