topic Re: using expression in chart dimension background color in QlikView

using expression in chart dimension background color

agigliotti — Mon, 11 Jul 2016 15:02:18 GMT

! !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

Re: using expression in chart background color

sunny_talwar — Mon, 11 Jul 2016 15:04:17 GMT

What exactly is going on? I didn't really get your question, can you elaborate?

Re: using expression in chart background color

Anonymous — Mon, 11 Jul 2016 15:09:46 GMT

there is no connection between Definition in Dimension Background Color and set Analysis in expressions

I have a Pivot table with a Background Color in one Dimension and two expressions with set Analysis

I does not effect the numbers

can you post a small sample, it might be something different

Re: using expression in chart dimension background color

agigliotti — Mon, 11 Jul 2016 15:13:06 GMT

SET_01.png shows the result with the if statement.

SET_02.png shows the expected result without the if statement.

Re: using expression in chart dimension background color

agigliotti — Mon, 11 Jul 2016 15:17:02 GMT

I noted the if expression affect the result only if I compare dimension value, ex if I do something like below:

If( 1=1, RGB(152, 187, 255) ) then it works as expected.

Re: using expression in chart dimension background color

boorgura — Mon, 11 Jul 2016 15:29:39 GMT

Please try this:

if( Dim1 = 'Value1' and rowno() <> 0, RGB(152, 187, 255) )

Re: using expression in chart dimension background color

Anonymous — Mon, 11 Jul 2016 15:30:58 GMT

it should work the same if you define your dimensionvalue: if (Dim='Value1',rgb....)

did you suppress when value is null and suppress Zero values?

I use 11.20 sr12

your Image _1 Shows more Dimension values than 2. where does this come from? is this the mistake you mention?

Re: using expression in chart dimension background color

Anil_Babu_Samineni — Mon, 11 Jul 2016 15:39:52 GMT

Please share sample Pivot table with Expected o/p?

Re: using expression in chart dimension background color

agigliotti — Mon, 11 Jul 2016 15:42:16 GMT

I tried but it's the same.

Attached the app with partial data.

I need to disable the "Suppress zero-values".

Yes it's what i'm saying in this thread.

Re: using expression in chart dimension background color

agigliotti — Mon, 11 Jul 2016 15:43:56 GMT

I did it

check on the first dimension background color expression.

the expected result should be equal to the SET_02.png image

Re: using expression in chart dimension background color

sunny_talwar — Mon, 11 Jul 2016 16:10:43 GMT

The attached application is looking for a User ID

Re: using expression in chart dimension background color

agigliotti — Mon, 11 Jul 2016 16:13:32 GMT

userid = qlik

password = view

Re: using expression in chart dimension background color

agigliotti — Tue, 12 Jul 2016 11:00:12 GMT

Any news on this issue ?

Could be a bug ?

Re: using expression in chart dimension background color

Anil_Babu_Samineni — Tue, 12 Jul 2016 11:10:03 GMT

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

Re: using expression in chart dimension background color

agigliotti — Tue, 12 Jul 2016 12:00:33 GMT

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 ?

Re: using expression in chart dimension background color

agigliotti — Tue, 12 Jul 2016 12:01:35 GMT

did you take a look at the sample app?

Re: using expression in chart dimension background color

Anil_Babu_Samineni — Tue, 12 Jul 2016 12:05:20 GMT

You want same as SET_02

You are referring DIR + GRO - PEZZI

Re: using expression in chart dimension background color

agigliotti — Tue, 12 Jul 2016 12:10:15 GMT

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.

Re: using expression in chart dimension background color

agigliotti — Tue, 12 Jul 2016 14:26:21 GMT

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

Re: using expression in chart dimension background color

Gysbert_Wassenaar — Tue, 12 Jul 2016 15:07:05 GMT

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.