topic Straight Tables - Colouring Text Based on Value above in QlikView

Straight Tables - Colouring Text Based on Value above

Sat, 29 May 2010 15:43:11 GMT

Yesterday Darius kindly provided me with a workaround to colour the text white in a straight table to stop dimensions repeating from row to row.

http://community.qlik.com/forums/t/29702.aspx

This worked a treat until i went and added a new dimension

So now i have

Dim1

Dim2

and an new dimension of

Dim1 & ' - ' & Dim2

In the first Dimension i have a formula on the text colour of

=If(Dim1 = Above(Dim1), White())

Which worked until i added the third dimension, but now does not change the colour, even though the Dim1 value in the above row is the same.

Can antbody advise as to why this has now stopped working? (in case you were wondering i need the new formula to solve a problem i was having with mini charts)?

Appreciate your help

Straight Tables - Colouring Text Based on Value above

Sat, 29 May 2010 17:41:32 GMT

hi,

i made Dim1&' '&Dim2 as expression instead of dimension and it is working fine

pls check the attached application

thanks

Straight Tables - Colouring Text Based on Value above

Sat, 29 May 2010 17:54:14 GMT

Thanks, but it i remove it from the dimensions my mini chart problem re-appears (see the thread link below)

http://community.qlik.com/forums/t/29728.aspx

So i really need to keep it as a dimension... any ideas?

Thanks for your help