topic List Box Highlight Current Week in QlikView

List Box Highlight Current Week

pkelly — Tue, 08 Mar 2011 17:26:12 GMT

Hi...

Hope someone can help me with this...

I have a list box which contains week numbers (caw_Week).

I have a variable which contains the current week number (varWeek).

To assists the user, what I want to do is highlight (not select) the current week in the list.

I have tried mucking around with the calculated font on the list box with no sucess...

Unsure if it is possible to do this or not...

Any assistance greatly appreciated.

Regards

Paul

List Box Highlight Current Week

Tue, 08 Mar 2011 17:36:14 GMT

Hello,

As far as I know we cannot write a expression for a ROW within a list box, and moreover the data is highlighted in QV only when its selected. May be you need a Macro to do this or use the weeks in a chart or somewhere else, where you can add some color code to the CurrentWeek.

ANDY

List Box Highlight Current Week

matt_crowther — Tue, 08 Mar 2011 18:34:13 GMT

Paul,

Attached is a 'dirty pre-sales' solution that may suit your needs.

I've created it based on a pure date but it still shows the possibilities of using a Straight as a pseudo-listbox - it even lets you add extra info into the mix.

Obviously doesn't behave entirely like a list box but may suit your needs.

With v10 you can add expressions to LB's (much like a Straight Table) so that may be worth a look.

Hope that helps,

Matt - Visual Analytics Ltd

List Box Highlight Current Week

pkelly — Tue, 08 Mar 2011 20:36:08 GMT

Thanks Matt

Think this will work....