Qlik Community

Ask a Question

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 
Search instead for 
Did you mean: 
jjustingkm
Contributor III
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.

RegionSalesOrdersPopulationShipped
A1040100020
B1040100022
C206040000
D1004010000
1 Solution

Accepted Solutions
jjustingkm
Contributor III
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.

View solution in original post

5 Replies
saran7de
Master
Master

Try this,

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

commQV06.PNG

jjustingkm
Contributor III
Contributor III
Author

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

 

 

RegionSalesOrdersPopulationShipped
A1040100020
B1040100022
saran7de
Master
Master

Let me assume the Calculated Expression is A+B

tab1:
LOAD * INLINE [
    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:

commQV10.PNG

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

jjustingkm
Contributor III
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)

jjustingkm
Contributor III
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.

View solution in original post