using expression in chart dimension background color

[agigliotti]

! !Hello,

I need to use something like this in my pivot table dim

ension background color:

if( Dim1 = 'Value1', RGB(152, 187, 255) )

i'm using set analysis in my pivot expression.

the question is:

why the above expression also affects the final result of aggregation sum ( {<...>} ) ?

it seems set analysis is not being applied anymore.

Can someone help me to understand why and if it works as expected ?

Currently i'm using the version 12 SR4.

Attached sample app: user = qlik password = view

Many thanks in advance.

Best Regards

Andrea

[sunny_talwar]

The attached application is looking for a User ID

[agigliotti]

userid = qlik

password = view

[agigliotti]

Any news on this issue ?

Could be a bug ?

[Anil_Babu_Samineni]

Andrea, Can i know what is diff b/w those two images. I am not getting any Difference. In that, What do you want?

Can you please share me the Expected o/p

[agigliotti]

the two images are not equal.

the difference is in the number of dimension values.

the expected result should be exactly as image SET_02 shows.

using the expression if( Dim1 = 'Value1', RGB(152, 187, 255) ) as dimension background color I get the wrong result as image SET_01 shows.

Is it clear ?

[agigliotti]

did you take a look at the sample app?

[Anil_Babu_Samineni]

You want same as SET_02

You are referring DIR + GRO - PEZZI

[agigliotti]

As I said before I need to see also dimension values with 0 as expression value.

Therefore I disabled the "suppress Zero values".

Try to comment the first dimension background color expression and see what happens to the dimension values number.

[agigliotti]

Just to share, I opened a new case at support portal.

[Gysbert_Wassenaar · Accepted solution]

Change

=if( MACROREGIONE_ConRiepilogo = 'TOTALE ITALIA' , $(vColorBackTotIta) )

into

=if( Only( { $(=$(vIfTOTITAODGRO)) } MACROREGIONE_ConRiepilogo) = 'TOTALE ITALIA' , $(vColorBackTotIta) )

Why? Your color expression returns results for more dimension values then your chart expression. You can consider this behavior as the same as what happens when you add that expression as just another chart expression. By adding the same set modifier to all expressions they will all return values for the same dimension values.