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
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
smusayev
Contributor II
Contributor II

Filter by Dimension Expression

Hi,

I have a chart that list top 10 non compliant nurses for a particular order.

My

Dimension:  NurseName --- (which list the names of various nurses).

Measure:  Count( {<QA_ABC_Nurs_Compliant = {'No'} >}  NurseName ) --- (Filters by Nurses Who are not Compliant)

I have one issue and wanted to know if anyone can help me with. 

I have another column called PhysicianOrder (that has orders, a, b, c, d, e)...

I would like to add another filter to this table and show only nurses that were not compliant that excludes a certain physician order (like order a).

( IN SQL what I would like to have would look like this  -  Select NurseName, Where QA_ABC_Nurs_Compliant =  'No' and  PhysicianOrder <> 'a')

How can I do the above with in the expression in my chart.  Please help.

1 Solution

Accepted Solutions
sunny_talwar

May be this:

Count({<QA_ABC_Nurs_Compliant = {'No'}, PhysicianOrder  -= {'a'}>} NurseName)


or


Count({<QA_ABC_Nurs_Compliant = {'No'}, PhysicianOrder  = {'*'} - {'a'}>}  NurseName)

View solution in original post

1 Reply
sunny_talwar

May be this:

Count({<QA_ABC_Nurs_Compliant = {'No'}, PhysicianOrder  -= {'a'}>} NurseName)


or


Count({<QA_ABC_Nurs_Compliant = {'No'}, PhysicianOrder  = {'*'} - {'a'}>}  NurseName)

View solution in original post