topic Re: Ignore a filter for the dimension colouring my graph in App Development

Ignore a filter for the dimension colouring my graph

megglerock — Thu, 01 Feb 2018 09:44:00 GMT

Hello,

I have a stacked bar graph that I am trying to get to ignore a filter on a different field. It has this formula normally:

count({<[Report Period]={'Rolling 30 Days'}>}[Broker Reference])

/count(total <Brand> {<[Report Period]={'Rolling 30 Days'}>} [Broker Reference])

which gives this graph:

However if I ignore any filters on the dimension Lapsed By using this formula

count({<[Report Period]={'Rolling 30 Days'},[Lapsed By]=>}[Broker Reference])

/count(total <Brand> {<[Report Period]={'Rolling 30 Days'},[Lapsed By]=>} [Broker Reference])

and then filter on a Lapsed By value the graph still shows the normal split but greys out segments that don't relate to this agent:

Is there a way to stop these from greying out? I am assuming it is because my second dimension that is colouring the graph is still being filtered on my Lapsed By selection, but don't know how to stop this.

Any solutions would be much appreciated!

Re: Ignore a filter for the dimension colouring my graph

sunny_talwar — Thu, 01 Feb 2018 17:59:30 GMT

You might be using an expression for color as well... in order to make sure that the colors don't go away, ignore Lapsed By in your color expression also

Re: Ignore a filter for the dimension colouring my graph

megglerock — Tue, 06 Feb 2018 09:50:33 GMT

I am using an expression for colour: by dimension [Reason], but as this is a dimension not a measure I don't know how to make it ignore Lapsed By ..

Re: Ignore a filter for the dimension colouring my graph

sunny_talwar — Tue, 06 Feb 2018 16:13:39 GMT

Something like this

Only({1} Reason)

Re: Ignore a filter for the dimension colouring my graph

megglerock — Mon, 12 Feb 2018 11:12:08 GMT

Sorry, I'm trying to colour using a dimension not an expression, so can't use the Only() function as it's aggregate. If I change to colour using an expression and try this formula nothing gets coloured at all.

Re: Ignore a filter for the dimension colouring my graph

sunny_talwar — Mon, 12 Feb 2018 16:19:59 GMT

I am not sure what you have, but may be omarbensalem‌ can help here

Re: Ignore a filter for the dimension colouring my graph

Qlik87 — Mon, 24 Jun 2019 13:39:47 GMT

Hi,

Did you get to the bottom of this, I've the same thing happening, the colours are ranked correctly but only show on on the dimension that is max for that category?