Discussion board where members can get started with QlikView.
I want to display in a table(straight , table box) some info that are filtered after an ID. And after I obtain the filtered info I would like to select a cell and to highlight the selected cell , and all the other data to remain in the table. Is there any way to achive this?
Some people also call this 'brushing'
Basically, you will need to clear the selection in the dimension(s) of your chart using set analysis
And use a background color expression like
=If(Count(DimensionField), Blue(), LightBlue() )
There is a demo how this works in the What's new in QV11 demo QVW:
Hy there Stefan,
I didn`t quite get what you explained. Maybe I wasn`t clear enaugh. What I want to do , is that i want to replicate the behavior of a List Box in a straight table or a table box. What I want to se is something like this : show my current selection on the first row , and the rest info to be shown in a gray background. Is this behavior possible to achive in a Table Box or a Straight Table?
You can try to create a straight table with your field as dimension and
Then use a background color attribute expression for the dimension like
=If(Count(FIELD), White(), LightGray() )
Use a sort expression (descending sort order) like
Hide the expression column on presentation tab.
Hello, I have tried what you said and it doesn`t work , or there is something that I`m doing wrong.
I`m using for dimension all my fields :FID , BNO , BDATE and FileName. And in the expression tab I wrote :
When I select the FID it shows me this table:
But when i select BNO it will show me only the selected BNO like this :
What I want is that when I select BNO to highlight the selected row , and the rest of the rows to remain on table on a gray background.