Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Purushothaman
Partner - Creator III
Partner - Creator III

Filter Selection: Straight Table

Hi Experts,

I have straight table with One dimension " BRAND" and 5 measures,

Purushothaman_0-1659345361514.png

 

I would like to Keep the Dimension BRAND  'Rolls Royce' to remain on top of the row in spite of any Filter selection in BRAND.

For Eg: If a user selects BMW in Brand Filter, I would like to show the table like below:

Purushothaman_1-1659346328876.png

 

Anyone, Please help

 

1 Solution

Accepted Solutions
MayilVahanan

Hi

If you want to keep one brand, try like below

Sum({<BRAND +={'Rolls Royce'}>}urexpression)

Thanks & Regards,
Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

3 Replies
MayilVahanan

Hi

If you want to keep one brand, try like below

Sum({<BRAND +={'Rolls Royce'}>}urexpression)

Thanks & Regards,
Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Purushothaman
Partner - Creator III
Partner - Creator III
Author

Hi @MayilVahanan 

where should i key in this expression, Becz I am using calculated dimension and 5 measures in a straight table.

Should I key in on both Calculated dimension and 5 measures as well? 

Please suggest. 

Thank you!

MayilVahanan

Hi 

if its calculated dimension, can u pls share the sample file? or if possible, can u try to move the calculated dimension in the script as new dimension

Thanks & Regards,
Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.