topic Re: Re: highlight row keep other data in QlikView

highlight row keep other data

Fri, 18 Oct 2013 15:33:49 GMT

Hi Guys,

Have any of you guys come across a way to highlight the row selected in a straight table but KEEP all the other data? I am looking to apply the functionality similar to a list box to a straight table. When you select something from a list box the item selected stays white and everything else turns gray (BUT YOU CAN STILL SEE IT). Is that possible in a straight table?

Message was edited by: Katie Webb

Re: highlight row keep other data

Fri, 18 Oct 2013 15:36:45 GMT

Can you atach an qvw?, and yes it is possible! (:

Re: highlight row keep other data

Anonymous — Fri, 18 Oct 2013 15:43:55 GMT

Katie

I don't believe his can be done exactly as you wish, but.................

....if you create a list box and for the Field choose <Expression> then within that combine the field you want as in something like this

=CalendarDate & ' ' & CalendarMonthName

It will act as a List Box, as it is a List Box and look vaguely like a Straight Table.

Best Regards, Bill

Re: highlight row keep other data

Fri, 18 Oct 2013 15:44:31 GMT

I added a really simple QVW... thanks!

Re: highlight row keep other data

Fri, 18 Oct 2013 15:46:38 GMT

I'm sorry Bill I am not quite following what you are explaining....

Re: highlight row keep other data

Clever_Anjos — Fri, 18 Oct 2013 15:46:41 GMT

Check if this solve what you need

Re: highlight row keep other data

Fri, 18 Oct 2013 15:49:13 GMT

YES!!! Can you give me a couple tips on how you did that?

THANK YOU!!!

Re: highlight row keep other data

Fri, 18 Oct 2013 15:50:55 GMT

Here you got , i only used Set Analysis and teh BackGroundColor from the both expressions,

Good Luck

Regards!!!

Re: highlight row keep other data

Clever_Anjos — Fri, 18 Oct 2013 15:53:29 GMT

Just set a Set Analysis to ignore your selection on field (this will show even if the field is not selected)

Then set a background color checking if the value is selected

Re: highlight row keep other data

Anonymous — Fri, 18 Oct 2013 15:54:47 GMT

Anjos

That is clever and yet simple, as in it looks like a bit of Set Analysis to simply ignore the selections on Dim1.

I'll remember that one, it is good.

Best Regards, Bill

Re: highlight row keep other data

Fri, 18 Oct 2013 16:15:10 GMT

Thank you so much, that is exactly what I was looking for. Do you know the syntax of the expression if there are multiple dimensions?

I have put the background color expressions in each dimension but it only works properly if I select the first dimension. I know I am missing something!

Re: Re: highlight row keep other data

Fri, 18 Oct 2013 16:25:19 GMT

Like this ?, good luck Katie!!!

Re: highlight row keep other data

Clever_Anjos — Fri, 18 Oct 2013 16:33:29 GMT

Well, I think you can use "and" operator

something like this

=if(Index(Dim1,Concat(distinct total Dim1,''))>0 AND Index(Dim2,Concat(distinct total Dim2,''))>0,LightGray())