Pivot Table with conditional formatting for different KPIs that is unaffected by selections

lukasrubner — Wed, 25 Nov 2020 16:16:04 GMT

Hell Everyone,

I am trying to create a table containing different formats (Whole numbers and percentages). This table also should not be affected by selections in a specific dimension (Sampletable attached).

I currently have a solution where my expression consists of an If statement like this:

IF(KPI = KPI1 OR KPI = KPI3 OR KPI = KPI4, num(expression,'#.'), num(expression, '#.##%'))

This does work as long as I do not select a KPI (needed in another part of the App). However, once I do select a KPI the formatting condition is ignored and all KPIs formatted according to the selection.

Is there a way to prevent that from happening?

Re: Pivot Table with conditional formatting for different KPIs that is unaffected by selections

rubenmarin — Tue, 15 Jan 2019 15:29:27 GMT

Hi, try adding {1} to ignore selctions, also macth can be easier to manage than adding 'ors':
If(Match(Only({1} KPI), 'KPI1','KPI3','KPI4'), num(expression,'#.'), num(expression, '#.##%'))

Only() returns the same value, is only used to apply set analysis ({1}).

topic Pivot Table with conditional formatting for different KPIs that is unaffected by selections in QlikView

Pivot Table with conditional formatting for different KPIs that is unaffected by selections

Re: Pivot Table with conditional formatting for different KPIs that is unaffected by selections