qlikview table. Format a background cell based on condition. like expression

[Anonymous]

Hi,

Can you change a background cell of a field based on a condition.

Currently the  Pivot table has this option but not the Table object.

Can anybody confirm ?

Thanks

[kaushiknsolanki]

Hi,

You can try below trick.

Create a composite key in script with the least level of granularity you want in chart.

Create a straight table add that Key as dimension and add all other dimensions as expression in straight table.

Go to presentation tab and click on the dimension and then click on Hide column.

This way you will have all fields as expression and you will get the required scroll plus the formatting options.

Regards,

Kaushik Solanki

[Anonymous]

Thanks Kaushik.

Above will work.

Unfortunately it is messy creating additional expressions.