Expression dinamic bkacground color

[juan_patrick]

Hi, i have a pivot table with some dimensions and one expression; one of the dimensions is year-month.

I want to put a background color in the expressions using two colors, in the expression bakground color i put this:

=$(vColorGrillaAlternativo(ColumnNo()))

and the definition of the variable is:

SET vColorGrillaAlternativo

= if(Odd($1),rgb(250,240,230),rgb(250,235,215));

The problem is that, for a month, i have no data for the expression so it repeat the same colour for background because for qlikview exists that column but dont show because have no data... ¿Any suggestions? Thanks!!

[juan_patrick]

No, I have a variable in the expression so i must write the same in the dimension and didnt work.

the variable is:

$(myVar(Param1,Param2))

and inside do:

AVG( {< $1 = {1}, Dg={'$2'} >} CANTTOTAL );

If i put this into the dimension :

=if( $(myVar(Param1,Param2)) <> 0, FINSEMANA)

FINSEMANA -> is the day that the data do a control cut.

the error:

Error in calculated dimension.

[#3]

You forgot the "Aggr" function. Something like that:

=if( Aggr($(myVar(Param1,Param2)), FINSEMANA) <> 0, FINSEMANA)

Maybe it will need add more independed keys to "aggr" parameters, if they placed in the left of this dimension.

[Gysbert_Wassenaar]

The example you posted works with the modified expression. Your example does not contain a field CANNOT or a field DIM_GRUPO. If you need help with that you will have to post a qlikview document that accurately models your real document.