topic Straight Table - Highlight Selected Fields just like List box in QlikView

Straight Table - Highlight Selected Fields just like List box

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am having a Straight Table for which I am displaying "All Values" for Dimension and removing check on "Suppressing Zero Values" so that I can view all the available options.

But when I select one of the value, its not showing which value I have selected.

As you can see above, I have selected 1000,2000 & 5000 but its not highlighting the row as if it was a list box below.

Is this something possible?

Re: Straight Table - Highlight Selected Fields just like List box

andrey_krylov — Tue, 04 Sep 2018 18:25:42 GMT

Hi, Samik. See attached, maybe that's what you need.

Re: Straight Table - Highlight Selected Fields just like List box

Anonymous — Wed, 05 Sep 2018 13:33:31 GMT

Andrew, you got exactly what I wanted. But I am not able to get how you did that in the file.

Can you please provide the exact screenshot of section where you did it.

Re: Straight Table - Highlight Selected Fields just like List box

andrey_krylov — Wed, 05 Sep 2018 13:51:24 GMT

Of course. Chart Properties -> Dimensions -> Used Dimensions -> Status History -> Background Color

And there is the expression

=If(GetSelectedCount([Status History]) > 0 and Match([Status History], $(=Chr(39) & Concat([Status History], Chr(39) & Chr(44) & Chr(39)) & Chr(39)) ), LightGreen(), White())

Re: Straight Table - Highlight Selected Fields just like List box

Anonymous — Wed, 05 Sep 2018 17:58:16 GMT

Thank you Andrew. Much appreciated!!