topic help to create pivot table with diffrent cell colors in QlikView

help to create pivot table with diffrent cell colors

Thu, 06 Nov 2014 12:30:42 GMT

Hi all,

Please find the attachment and help to create pivot table with diffrent cell colors

Thanks,

Venkat

rubenmarin — Thu, 06 Nov 2014 12:58:55 GMT

Hi Venkat,

In the 2nd dimension, expand dimension and set background color like:

If(FieldName='Industry', green(),

If(FieldName='Registrations', yellow(),

If(FieldName='Market Share', blue())))

In expressions do the same, expand expression and set background color, can be tricky for null values and vertical dimension, maybe you have to use:

If(Only({1}FieldName)='Industry', green(),

If(Only({1}FieldName)='Registrations', yellow(),

If(Only({1}FieldName)='Market Share', blue())))

Change green, yellow and blue for the rgb codes you want for colors. And FieldName for the name of the field in the 2nd. column.

Thu, 06 Nov 2014 13:03:18 GMT

hi Ruben,

am not getting you if possible could please attach a sample >qvw file for my better understanding

thanks in advance

Venkat

rubenmarin — Thu, 06 Nov 2014 13:56:24 GMT

Hi, check backgroud color in 'Metric' dimension and in 'Value' expression.

May not work depending on how is generated your 'Metric' dimension and for null values.

If doesn't work upload a sample to make test.