Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
hammermill21
Creator III
Creator III

Filter KPI with one filter but not the other

Hello!

I have a KPI that updated depending on the filter selected. I have two filters, Building and Week. I need for my KPI NOT to change when a week is selected. I tried a few things like this:

Count({$<Week=>} {<xtype={'Eyewash Station'}>} xtype)

But that doesn't work, any ideas?

 

Thanks!

1 Solution

Accepted Solutions
agigliotti

maybe this:
Count( {< Week=, xtype = {'Eyewash Station'} >} xtype )
I hope it helps.
The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it

View solution in original post

4 Replies
agigliotti

maybe this:
Count( {< Week=, xtype = {'Eyewash Station'} >} xtype )
I hope it helps.
The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it
hammermill21
Creator III
Creator III
Author

Oh, I see what I did wrong!

 

THANK YOU!!!

nbuscemi
Contributor III
Contributor III

What if I do NOT want the total residents in a KPI to change when multiple filters are applied? Because the residents are always the same no matter what filter is applied.

Filters are EXPENSE CATEGORY, TRIAL PHASE,  YEAR, drill-down dimension THERAPEUTIC AREA, PRODUCT?

 

Thanks

agigliotti

try this:
Count( {1< xtype = {'Eyewash Station'} >} xtype )

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it