Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
kgordish
Contributor II
Contributor II

KPI and Ignore Filter Selection

Can I get some assistance with adjusting my code? 

I want my KPI to ignore filters.
This is one situation where I miss Tableau. There you can simply check a box to let a filter work on an object or not. 

=IF(SUM({<[Metric Name]={'XYZ'},[KPI Latest Month Figures]={'Yes'}>}Adjusted_Metric_Value)<0.001,'-',
ROUND(SUM({<[Metric Name]={'XYZ'},[KPI Latest Month Figures]={'Yes'}>}Adjusted_Metric_Value),0.1)&'%')
 
Thank you in advance. 

Labels (3)
1 Solution

Accepted Solutions
gballester
Creator
Creator

Hi,

When you want an expression not to consider the values ​​of a given filter, what you should do is include the name of the field not to be taken into account.

In the example attached, the expression is sum (sales), and the other expression ignores the Year filter.

sum (sales)                                      sum ({<year>} sales)

the set analysis {<year>}  indicate the year selections is ignored in the sum

View solution in original post

5 Replies
gballester
Creator
Creator

Hi,

When you want an expression not to consider the values ​​of a given filter, what you should do is include the name of the field not to be taken into account.

In the example attached, the expression is sum (sales), and the other expression ignores the Year filter.

sum (sales)                                      sum ({<year>} sales)

the set analysis {<year>}  indicate the year selections is ignored in the sum

View solution in original post

Nicole-Smith

In addition to the previous reply, if you want to ignore ALL filters, instead of listing out each one individually, you can simply add a 1 in the beginning of your set analysis:
=IF(SUM({1<[Metric Name]={'XYZ'},[KPI Latest Month Figures]={'Yes'}>}Adjusted_Metric_Value)<0.001,'-',
ROUND(SUM({1<[Metric Name]={'XYZ'},[KPI Latest Month Figures]={'Yes'}>}Adjusted_Metric_Value),0.1)&'%')

kgordish
Contributor II
Contributor II
Author

@gballester 

Yes, @gballester  "Year" is the particular filter that is interfering with my KPI. 
Due to length of my formula, can you show me where to insert year?

After inserted {1} into my formula, realized I wanted to keep region filter working and have year deactivated. 

gballester
Creator
Creator

borarset.png

smgt90
Contributor II
Contributor II

Thanks! this is exactly what I was looking for