Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

help to create pivot table with diffrent cell colors

Hi all,

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

Thanks,

Venkat

3 Replies

Re: help to create pivot table with diffrent cell colors

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.

Not applicable

Re: help to create pivot table with diffrent cell colors

hi Ruben,

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

thanks in advance

Venkat

Re: Re: help to create pivot table with diffrent cell colors

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.