Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Highlight selection and keep the other information displayed in the table.

Hello,

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?

Thank you.

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

I think you need to include the other two fields you don't want to filter in the set expression:

if(GetFieldSelections(FID)>=1,Count({<FILE_NAME, BNO, BDATE>} FILE_NAME))

View solution in original post

6 Replies
Highlighted
MVP
MVP

Some people also call this 'brushing'

Basically, you will need to clear the selection in the dimension(s) of your chart using set analysis

=Sum({<DimensionField=>} Value)

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:

Qlik Demos: See QlikView in Action | Demo.Qlik.Com

2016-09-15 21_49_35-Whats New in QlikView11.qvw.png

Highlighted
Creator III
Creator III

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?

Highlighted
MVP
MVP

You can try to create a straight table with your field as dimension and

=Count({<FIELD>} FIELD)

as expression.

Then use a background color attribute expression for the dimension like

=If(Count(FIELD), White(), LightGray() )

Use a sort expression (descending sort order) like

=Rank(FIELD)

Hide the expression column on presentation tab.

2016-09-16 19_35_34-QlikView x64 Personal Edition - [C__Users_Stefan_Downloads_comm229627.qvw_].png

Highlighted
Creator III
Creator III

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 :

if(GetFieldSelections(FID)>=1,Count({<FILE_NAME>} FILE_NAME)).

When I select the FID it shows me this table:

Capture1.PNG

But when i select BNO it will show me only the selected BNO like this :

Capture2.PNG

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.

Thank you.

Highlighted
MVP
MVP

I think you need to include the other two fields you don't want to filter in the set expression:

if(GetFieldSelections(FID)>=1,Count({<FILE_NAME, BNO, BDATE>} FILE_NAME))

View solution in original post

Highlighted
Creator III
Creator III

Thanks a lot Stefan. That worked.