topic Re: KPI and Ignore Filter Selection in QlikView

KPI and Ignore Filter Selection

kgordish — Sat, 16 Nov 2024 01:19:50 GMT

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.

Re: KPI and Ignore Filter Selection

gballester — Thu, 06 Feb 2020 21:26:05 GMT

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

Re: KPI and Ignore Filter Selection

Nicole-Smith — Thu, 06 Feb 2020 22:53:03 GMT

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)&'%')

Re: KPI and Ignore Filter Selection

kgordish — Fri, 07 Feb 2020 14:06:52 GMT

@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.

Re: KPI and Ignore Filter Selection

gballester — Fri, 07 Feb 2020 15:28:36 GMT

Re: KPI and Ignore Filter Selection

smgt90 — Fri, 19 Mar 2021 18:57:05 GMT

Thanks! this is exactly what I was looking for