Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
sweety0912
Contributor II
Contributor II

Need Help

Hi,

I have a table box with sample data like shown in below. If i select any filter left side or if i select any row that row should high late but the data should show remain same. for ex: if i select id=2 second row should high late data should display based on the selection but table box should not change. Can any one help on this? 

 

Input    
IDTestFirstOneLastOneNotSame
1AABB11
2AACC11
3BBCC22

 

 

1 Solution

Accepted Solutions
dplr-rn
Partner - Master III
Partner - Master III

Just hide the column like i did in sample qvw.

or put one of your dimensions as expression e.g. Only({<ID=>}Test)

View solution in original post

6 Replies
dplr-rn
Partner - Master III
Partner - Master III

it wont be possible in table box.
you will need to move it into a Straight Table.
Use set analysis to ignore slections and you can use custom format cell to hightlight conditionally as well
sweety0912
Contributor II
Contributor II
Author

Thanks for reply!Can you please send me any sample qvw with that option? 

dplr-rn
Partner - Master III
Partner - Master III

find attached a simple example

i have used a dummy expression with set analysis to ignore selection of ID and used background color expressions on all the dimensions.

 

Hope it helps

sweety0912
Contributor II
Contributor II
Author

I really appreciate your help!

But I am just using straight table to show the dimensions. I cant use the Sum({<ID=>}1) because it will sum up.  Can you help me in this scenario?

dplr-rn
Partner - Master III
Partner - Master III

Just hide the column like i did in sample qvw.

or put one of your dimensions as expression e.g. Only({<ID=>}Test)

sweety0912
Contributor II
Contributor II
Author

Thank you very much!