Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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!

Labels (3)
1 Solution

Accepted Solutions
Kashyap_R
Partner - Specialist
Partner - Specialist

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

Thanks and Regards
Kashyap.R

View solution in original post

5 Replies
Kashyap_R
Partner - Specialist
Partner - Specialist

Hi

Please go through the attached QVF sheet3 

Hope this helps

Thanks

Thanks and Regards
Kashyap.R
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_R
Partner - Specialist
Partner - Specialist

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

Thanks and Regards
Kashyap.R
jdean1012
Contributor III
Contributor III
Author

Awesome!  THANKS SO MUCH!!!