topic Re: color code changes in QlikView

color code changes

prma7799 — Mon, 08 Jun 2015 06:18:11 GMT

Dear All,

I have a below requirement that i want Growth % color in below format

(Single digit – black font, double digit – green font, de-growth – in red)

Thanks

Re: color code changes

robert_mika — Mon, 08 Jun 2015 06:59:05 GMT

Do you mean format of the numbers?

If Yes, in your expression "Text Color" option

=if(Num<0,RGB(255,0,0),if(Num<0.1,Black(),if(Num<1,GReen(),)))

Re: color code changes

prma7799 — Mon, 08 Jun 2015 07:11:54 GMT

Thanks Robert.

But i want to change symbol color which is present in Pink with respect number digit.

suppose 8----black

88--green

-8 --red

Thanks

Re: color code changes

Mon, 08 Jun 2015 07:17:39 GMT

Hi,

Please check the attached qvw.

Regards,

Jemimah

Re: color code changes

hariprasadqv — Mon, 08 Jun 2015 07:29:27 GMT

I Chime Robert way.

Re: color code changes

ankit777 — Mon, 08 Jun 2015 08:22:28 GMT

Try something like this.

Re: color code changes

prma7799 — Mon, 08 Jun 2015 09:05:09 GMT

Hi Jemimah,

I tried your formula but in my scenario but all values getting in red.

Re: color code changes

Mon, 08 Jun 2015 09:07:59 GMT

Hi,

Could you please post a sample qvw containing sample data.

Regards,

Jemimah

Re: color code changes

prma7799 — Mon, 08 Jun 2015 09:26:43 GMT

Hi Jemimah,

I am unable to send qvw file . give me another solution

Thanks

Re: color code changes

Mon, 08 Jun 2015 09:43:04 GMT

Hi,

Can you send some sample data around 5 rows of data ?