topic Re: How to write a script for conditional color in QlikView

How to write a script for conditional color

Wed, 06 Jan 2016 10:08:28 GMT

Hi all,

Anyone could teach me how to write a script to have a conditional color (e.g. +ve figure shows red color; -ve figure shows black color).

Best Regards,

Alan

Re: How to write a script for conditional color

sunny_talwar — Wed, 06 Jan 2016 12:35:02 GMT

May be like this:

If(YourExpression > 0, LightRed(), Black())

and it needs to go here:

but you won't be able to include Target Variance (days) and 48 with different formatting in one text box objects. You can use two different text box objects and use the above for the object with the expression.

Re: How to write a script for conditional color

HirisH_V7 — Wed, 06 Jan 2016 12:45:23 GMT

Hi ,

May be like this,

Data:
LOAD * INLINE [
    ID, Score
    1, 48
    2, -49
    3, 50
    4, -89
    5, 98
];

Output:

In Expression Back Ground Color:

=if(Score>=0,Black(),LightRed())

There in place of '0' you Can use your cut off value -> 48.

PFA,

HTH,

Hirish

Re: How to write a script for conditional color

Thu, 07 Jan 2016 02:51:17 GMT

Thanks all,

I tried Sunny T's method (it is easier for me). Unfortunately, still unsuccessful.

Best Regards,

Alan

Re: How to write a script for conditional color

HirisH_V7 — Thu, 07 Jan 2016 08:34:53 GMT

Hi,

Change your expression like this,

=IF(Num($(Close Debtor Provision Current)/1000,'#,##0')>=0,Black(),LightBlue())

Else Check your variable once.It is giving your desired number or not .

Hope this helps,

Regards,

Hirish

Re: How to write a script for conditional color

Thu, 07 Jan 2016 09:39:44 GMT

Thanks Hirish V,

But still unsuccesesful.

Best Regards,

Alan

Re: How to write a script for conditional color

sunny_talwar — Thu, 07 Jan 2016 09:58:31 GMT

Or even this:

=If($(Close Debtor Provision Current) >= 0, Black(), Blue())

Re: How to write a script for conditional color

HirisH_V7 — Thu, 07 Jan 2016 09:59:38 GMT

Hi ,

Can your be able to share your app!!

-Hirish

Re: How to write a script for conditional color

HirisH_V7 — Thu, 07 Jan 2016 10:05:27 GMT

Hi ,

Did gone through your variable output . Check it once.

Hirish

Re: How to write a script for conditional color

Thu, 07 Jan 2016 10:53:32 GMT

same result, can't display the figure.

Re: How to write a script for conditional color

prabir_c — Thu, 07 Jan 2016 11:33:42 GMT

Hi,

Try this..

=IF($(Close Debtor Provision Current)/1000>=0,color(201),color(102))

Re: How to write a script for conditional color

sunny_talwar — Thu, 07 Jan 2016 12:15:41 GMT

Would you be able to share your application or a sample where it isn't working?

Re: How to write a script for conditional color

rajeshforqlikvi — Thu, 07 Jan 2016 12:28:21 GMT

Hi,

You go your expression tab pick any expression and expand that one you will get background color ,text color, and more double click on this and write the expression like below :

if ( sum(sales) > 0 , Green() ,

if (sum(sales)< 0 , red()))

Regards

Rajesh Kumar

Re: How to write a script for conditional color

Fri, 08 Jan 2016 01:21:48 GMT

Hi Prabir,

I tried but still unsuccessful.

Best Regards,

Alan

Re: How to write a script for conditional color

Fri, 08 Jan 2016 01:28:52 GMT

Hi Rajesh Kumar,

Your method is OK, but is limited to make the whole text box become conditional color. My intention is to make the figure or wordings to become conditional color in a statement.

Best Regards,

Alan