Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jacek2703
Contributor II
Contributor II

How to display only selected fields within dimension

Hello there,

how to show only selected fields in my table with no using filter panel and alternate states?

Field: = [T1 Partner Name]

Any idea? Thanks for any help!

1.JPG

 

 

1 Solution

Accepted Solutions
GaryGiles
Specialist
Specialist

Use the aggr() and replace the values with the desired values:

Aggr(Only({$<[T1 Partner Name]={'Techn. . . .','AMTE. . . .','Ronlig. . . .'}>} [T1 Partner Name]), [T1 Partner Name])

View solution in original post

1 Reply
GaryGiles
Specialist
Specialist

Use the aggr() and replace the values with the desired values:

Aggr(Only({$<[T1 Partner Name]={'Techn. . . .','AMTE. . . .','Ronlig. . . .'}>} [T1 Partner Name]), [T1 Partner Name])

View solution in original post