formating table values with colours

[#1]

Hi QlikView-freaks, a simple one. Is there a way to format table values like in the attached? I did some research but found nothing.

Thanks in advance!

David

[MayilVahanan]

Hi

Yes you can able to do this.

By click,  '+' sign in expression tab, in tat you can give expression in background color as your requirement.

[jonathandienst]

Hi

That looks like a heatmap. Click the + next to the expression on the expression tab, click teh background expression and in the expression editor, select Color Mix Wizard from the File menu. Follow the instructions and you should get the output you require.

HTH

Jonathan

[#4]

not sure I understand.... I don´t want to assign a colour manually. The idea is that depending on values qlikview assign the color. high values are green and low ones red (like excel does).

thanks, David

[MayilVahanan]

Hi

Use colormix() function in background color of the expression..

Try like attachments.

[#6]

What is the condition on the basis of which you want to assign colors?

For Eg. something like if the values is greater than 100 then it should be red/green or anything.

[jonathandienst]

David Rodriguez wrote:

not sure I understand.... I don´t want to assign a colour manually. The idea is that depending on values qlikview assign the color. high values are green and low ones red (like excel does).

thanks, David

That's what the color mix wizard does for you...