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

[agigliotti]

Thanks but in the meanwhile I found the below expression:

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

and it also works fine.

However I thought it should not be connection with chart expression as Rudolf said.

Is it the QIX expected behavior since ever ?