topic Re: How to indicate column with Color codes? in QlikView

How to indicate column with Color codes?

Shubham_Deshmukh — Thu, 03 Aug 2017 13:52:54 GMT

I want to show colored upward and downward arrows(Not background color) with values .

( e.g. If value < 0 red, else green)

Re: How to indicate column with Color codes?

Anil_Babu_Samineni — Thu, 03 Aug 2017 15:10:01 GMT

May be this?

If(Value <0, 'qmem://<bundled>/BuiltIn/arrow_n_g.png', 'qmem://<bundled>/BuiltIn/arrow_s_r.png')

Re: How to indicate column with Color codes?

Fri, 04 Aug 2017 03:59:35 GMT

Simply upload a green arrow and red arrow with the specific condition in the 'If'

Re: How to indicate column with Color codes?

Fri, 04 Aug 2017 04:43:35 GMT

You can do this one. Create a Line/Arrow Object and select the type of arrow you want .

And after that give the Condition in the conditional field. You can create two different Line/Arrow objects for Profit or Gain and give the respective conditions in the Conditional Field. This worked out for me. Hope this helps you.

Re: How to indicate column with Color codes?

arvind_patil — Fri, 04 Aug 2017 07:38:29 GMT

Hi Shubham,

It will work in your case:

If(Value <0, 'qmem://<bundled>/BuiltIn/arrow_n_g.png', 'qmem://<bundled>/BuiltIn/arrow_s_r.png')

Thanks,

Arvind Patil

Re: How to indicate column with Color codes?

prma7799 — Fri, 04 Aug 2017 07:47:52 GMT

Try like this

if(value < 0 ,'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.png')

You will get like below ...

Re: How to indicate column with Color codes?

Shubham_Deshmukh — Mon, 07 Aug 2017 09:59:51 GMT

In cell value, only following link is showing,

qmem://<bundled>/BuiltIn/arrow_n_g.png

Re: How to indicate column with Color codes?

Anil_Babu_Samineni — Mon, 07 Aug 2017 10:03:56 GMT

You must change representation from text to image

Re: How to indicate column with Color codes?

Shubham_Deshmukh — Mon, 07 Aug 2017 10:19:59 GMT

Not working sir

Re: How to indicate column with Color codes?

Shubham_Deshmukh — Mon, 07 Aug 2017 10:20:39 GMT

=If((A-B) <= -1,'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.png');

This is exp.

Re: How to indicate column with Color codes?

Anil_Babu_Samineni — Mon, 07 Aug 2017 10:23:25 GMT

What are the A and B in your measure. If it returns numeric should work.

As I said, do you change your representation

Re: How to indicate column with Color codes?

Shubham_Deshmukh — Mon, 07 Aug 2017 10:42:06 GMT

Ya I changed the representation to image then it is showing ' - '

A & B are just values , whose diff will be +ve and - ve values