Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jdean1012
Contributor III
Contributor III

Data Handling with Multiple Measures

I have a table with multiple measures.  I'd like to filter out rows where Measure #1 = 0 while ignoring Measure #2.  Un-checking "Include Zero Values" under Add-Ons/Data Handling evaluates both measures and only filters out the rows where both #1 and #2 are zero.

Thanks for any assistance in advance!

1 Solution

Accepted Solutions
kashyap
Partner
Partner

Hi 

Try this

Go to Data >> Dimension  >> Limitation >> Exact value

Select   >=   2

Make sure that the dimension limit is based on non-compliant tickets measure if it is pointing to some other measure make sure to bring this measure up. I have tried on measure items it is working.

Hope this helps

Thanks

View solution in original post

5 Replies
kashyap
Partner
Partner

Hi

Please go through the attached QVF sheet3 

Hope this helps

Thanks

jdean1012
Contributor III
Contributor III
Author

Thanks for the reply.
Unfortunately, my measures are master items, which I don't think are allowed in dimension formulas.

jdean1012
Contributor III
Contributor III
Author

Here is a more detailed explanation of the problem.  The "Non-Compliant Tickets" master measure is the field I would like to use to filter the table.  It is defined as follows:

Sum({<
[ReportFY] = {'Yes'},
[Regional Indicator] = {'International'},
[Customer] = {'Non-Customer'},
[Compliance] = {'Non-Compliant'}
>} [True Ticket Count])

I would like to see ONLY the rows in the yellow box, or, those travelers with 2 or more non-compliant tickets.

Qlik Sense Measure Filter Problem.png

kashyap
Partner
Partner

Hi 

Try this

Go to Data >> Dimension  >> Limitation >> Exact value

Select   >=   2

Make sure that the dimension limit is based on non-compliant tickets measure if it is pointing to some other measure make sure to bring this measure up. I have tried on measure items it is working.

Hope this helps

Thanks

View solution in original post

jdean1012
Contributor III
Contributor III
Author

Awesome!  THANKS SO MUCH!!!