topic Re: formating table values with colours in QlikView

formating table values with colours

Mon, 25 Nov 2013 15:09:53 GMT

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

Re: formating table values with colours

MayilVahanan — Mon, 25 Nov 2013 15:12:44 GMT

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.

Re: formating table values with colours

jonathandienst — Mon, 25 Nov 2013 15:22:40 GMT

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

Re: formating table values with colours

Mon, 25 Nov 2013 15:26:25 GMT

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

Re: formating table values with colours

MayilVahanan — Tue, 26 Nov 2013 05:29:56 GMT

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

Try like attachments.

Re: formating table values with colours

Tue, 26 Nov 2013 05:37:47 GMT

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.

Re: formating table values with colours

jonathandienst — Tue, 26 Nov 2013 05:43:34 GMT

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...