# New to Qlik Sense

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

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for
Did you mean:
Contributor III

## Filter table using Measure displayed

Hi All,

I have table like below . My requirement is to filter out the records where shipped =0, I noticed that I can achieve it using the limitation option related to dimension in this case , sector. But the issue is , I have to change the position of 'Shipped' next to Region. The dimension limitation always compare the first measure in the table.

 Region Sales Orders Population Shipped A 10 40 1000 20 B 10 40 1000 22 C 20 60 4000 0 D 100 40 1000 0
1 Solution

Accepted Solutions
Contributor III
Author

I have found the solution for this problem, i can use an expression like this.

If(aggr(Measure)),Region)>0,Region), with the dimension and filter out nulls.

5 Replies
Master

Try this,

Only({<Shipped={"<>0"}>}Shipped)

Contributor III
Author

Not sure , I understood your solution, My end result should look like this. And also Shipped is a calculated Measure.

 Region Sales Orders Population Shipped A 10 40 1000 20 B 10 40 1000 22
Master

Let me assume the Calculated Expression is A+B

``````tab1:
Region, Sales, Orders, Population, A, B
A, 10, 40, 1000, 10, 10
B, 10, 40, 1000, 10, 12
C, 20, 60, 4000, 0, 0
D, 100, 40, 1000, 0, 0
];``````

Output:

Note: You can also filter A+B>0 in the Dimension

Contributor III
Author

Thanks for the reply Saran,  all the measures are set analysis expressions. Anyway I brought them using variable as shown below. But still not working as expected. and also noticed that Only gives Boolean results.

Only({<Region={"(\$(A)>0"}>} Sales)

Contributor III
Author

I have found the solution for this problem, i can use an expression like this.

If(aggr(Measure)),Region)>0,Region), with the dimension and filter out nulls.