Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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))
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
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
=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.
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:
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.
Thank you.
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))
Thanks a lot Stefan. That worked.