topic Re: Base on value color change in QlikView

Base on value color change

arulsettu — Mon, 02 Mar 2015 05:04:22 GMT

i am having value in straight table using expression like sum(amount) so result like this

amount

2500

2320

2210

2010

1980

1500

1504

based on the input box value it will bring the highest value in straight table.

now i want to show difference in color. for example red color means based on value the red color should be differ

please suggest some ideas

thanks

Re: Base on value color change

arulsettu — Mon, 02 Mar 2015 05:18:55 GMT

now the color is blue based on the value the blue should change like ligh tblue..lighter than before, lighter than before

Re: Base on value color change

neha_sri — Mon, 02 Mar 2015 05:20:47 GMT

Hi Arul

If I correctly understood your question you can do something like this.

In expression>BAckground Color, you can write your value and coressponding to that you can give the color

if(amount<=1500,red(),if(amount>=2300,blue()))

Regards.

Re: Base on value color change

arulsettu — Mon, 02 Mar 2015 05:23:06 GMT

thanks fore reply

i am having input box if enter 20 it will show highest 20 value. so the amount value will differ

Re: Base on value color change

jagan — Mon, 02 Mar 2015 05:27:45 GMT

Hi,

Try this expression

=RGB(Div(Sum(Amount) * 25, 255), 0, 0)

Hope this helps you.

Regards,

Jagan.

Re: Base on value color change

robert_mika — Mon, 02 Mar 2015 05:30:28 GMT

is this what you have in mind?

Re: Base on value color change

arulsettu — Mon, 02 Mar 2015 05:31:35 GMT

Hi Jagan

showing every row in same color

Re: Base on value color change

arulsettu — Mon, 02 Mar 2015 05:34:11 GMT

yes excatly

Re: Base on value color change

jagan — Mon, 02 Mar 2015 05:39:02 GMT

Hi Arul,

Please check the file attached it all showing in different colors for the numbers you have given, if your numbers are closer then you can't see much difference.

Regards,

Jagan.

Re: Base on value color change

arulsettu — Mon, 02 Mar 2015 05:49:04 GMT

Amount is expression label name

Re: Base on value color change

jagan — Mon, 02 Mar 2015 05:51:50 GMT

Hi,

You can also use Expression Label name in square brackets, instead of direct expression.

Regards,

Jagan.

Re: Base on value color change

arulsettu — Mon, 02 Mar 2015 05:55:14 GMT

Hi jagan,

i use this in expression background color

=RGB(Div(Sum([Settlement Amount]) * 25, 255), 0, 0)

every row in grey color

Re: Base on value color change

robert_mika — Mon, 02 Mar 2015 06:00:15 GMT

Maybe like this

Based on your data set

=if(sum(color)<>Above(sum(color)),rgb(above(sum(color))/10,0,0))

This will only

Re: Base on value color change

jagan — Mon, 02 Mar 2015 06:01:04 GMT

Hi,

Can you attach the sample file?

Regards,

Jagan.

Re: Base on value color change

arulsettu — Mon, 02 Mar 2015 06:02:38 GMT

doing binary load around 500 mb size. any possible way to upload

thanks

Re: Base on value color change

arulsettu — Mon, 02 Mar 2015 06:05:32 GMT

it showing values in negative(wrong values)

Re: Base on value color change

arulsettu — Mon, 02 Mar 2015 06:09:01 GMT

this is my expression in straight table

amount:

=(sum({<CLM_TRANS_ID={"=CS_CLM_TRANS_ID"},CS_SETL_DTYear={$(vCurrentYear)}, CS_EST_TYPE={1}>}CS_AMT_LC_1)

-sum({<CLM_TRANS_ID={"=CS_CLM_TRANS_ID"},CS_SETL_DTYear={$(vCurrentYear)},CS_EST_TYPE={3}>}CS_AMT_LC_1))

-(sum({<CLM_TRANS_ID={"=CS_CLM_TRANS_ID"},CS_SETL_DTYear={$(vCurrentYear)},CS_EST_TYPE={2}>}CS_AMT_LC_1)

-(sum({<CLM_TRANS_ID={"=CS_CLM_TRANS_ID"},CS_SETL_DTYear={$(vCurrentYear)},CS_EST_TYPE={4}>}CS_AMT_LC_1)))

Re: Base on value color change

robert_mika — Mon, 02 Mar 2015 06:17:48 GMT

You can play with the RGB criteria

rgb(above(sum(color))/10,100,200)

Thi is not ideal solution as let say shades of blues in RGB are spread among many numbers

Re: Base on value color change

arulsettu — Mon, 02 Mar 2015 06:24:43 GMT

i will post the app please wait

Re: Base on value color change

arulsettu — Mon, 02 Mar 2015 06:25:28 GMT

i dint get exactly