Qlik Community

New to Qlik Sense

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

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
rsingh43
Creator
Creator

Count Match

Hi,

I am having an issue with my count for matches values. As you can see below the count seems to be including an additional column (highlighted in yellow):

Qlik.PNG

The expression I am using is for this pivot table is:

Row: =IF(OrderPODDateYear>2017,PODDATEMONTH)

Column: =If(Match([PriorityLevel],'AOG','Routine'), PriorityLevel)

Measure: =count(DISTINCT OrderID)

Is there something I can do so it only returns Routine and AOG figures?

Thanks

1 Solution

Accepted Solutions
YoussefBelloum
Champion
Champion

Hi,

Try just filtering on the expression, like this:

=count(DISTINCT {<PriorityLevel={"=Match([PriorityLevel],'AOG','Routine')"}>} OrderID)

View solution in original post

4 Replies
YoussefBelloum
Champion
Champion

Hi,

Try just filtering on the expression, like this:

=count(DISTINCT {<PriorityLevel={"=Match([PriorityLevel],'AOG','Routine')"}>} OrderID)

rsingh43
Creator
Creator
Author

THANKS!

it worked

YoussefBelloum
Champion
Champion

You're welcome!

to simplify, this will also work:

=count(DISTINCT {<PriorityLevel={'AOG','Routine'}>} OrderID)


rsingh43
Creator
Creator
Author

Thanks again!