Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
prma7799
Master III
Master III

color code changes

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)

in colours.png

Thanks

9 Replies
robert_mika

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(),)))

08-Jun-15 7-58-38 AM.jpg

prma7799
Master III
Master III
Author

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

Not applicable

Hi,

Please check the attached qvw.

Regards,

Jemimah

hariprasadqv
Creator III
Creator III

I Chime Robert way.

ankit777
Specialist
Specialist

Try something like this.

prma7799
Master III
Master III
Author

Hi Jemimah,

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

Not applicable

Hi,

Could you please post a sample qvw containing sample data.

Regards,

Jemimah

prma7799
Master III
Master III
Author

Hi Jemimah,

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

Thanks

Not applicable

Hi,

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