Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
rubenmarin

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
Author

hi Ruben,

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

thanks in advance

Venkat

rubenmarin

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.