Qlik Community

New to Qlik Sense

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

cancel
Showing results for 
Search instead for 
Did you mean: 
wasimalrayes
Contributor II
Contributor II

Filter a displayed column by another column

Hi

I have set a table as below, but i am looking to filter to only show a certain Name from a column that i have not displayed.

I.e. right now i have the table as

IDFigure
HJA77
HJA82
HJA910
HJA1020
HJA118
HJA12-17
HJA13-1
HJA148
HJA152

 

the source has the below columns 

NAMEIDFigure
BMWHJA77
VWHJA82
HondaHJA910
BMWHJA1020
VWHJA118
HondaHJA12-17
BMWHJA13-1
VWHJA148
HondaHJA152

 

I want my table column ID to be filtered just to show NAME=BMW i.e. as below

IDFigure
HJA77
HJA1020
HJA13-1

 

Labels (1)
2 Replies
Kushal_Chawda

@wasimalrayes  try below expression

=sum({<Name={'BMW'}>}Figure)

wasimalrayes
Contributor II
Contributor II
Author

Thanks

 

I am trying this under the SORTING TAB and adding an expression for the 

=sum({<NAME={'BMW'}>}[Figure])

 

But it does not filter out just the BMW in the table?