topic Re: Different Colors for Different Conditions in QlikView

Different Colors for Different Conditions

300sss300 — Wed, 25 Nov 2020 16:16:04 GMT

HI All,

I am analyzing the numeric values between 2 periods lets say year 2015 and 2016.

If variation in "chart" is positive color should be Green.... If negative it should be red....???????????????????

Also if I want to make a pivot table How can I use down arrow and up arrow symbols With % variations.

Best Regards,

stalwar1‌brunobertels‌

Re: Different Colors for Different Conditions

Kushal_Chawda — Wed, 25 May 2016 06:55:30 GMT

see this

Red or green arrow image based on values

Re: Different Colors for Different Conditions

tamilarasu — Wed, 25 May 2016 07:05:13 GMT

Hi Khyam,

Khyam Aslam wrote:

If variation in "chart" is positive color should be Green.... If negative it should be red....???????????????????

You can try back ground expression like If(YourExpression >0,LightGreen(),LightRed())

Also if I want to make a pivot table How can I use down arrow and up arrow symbols With % variations.

You can check the below link for symbol representation.

Qlik Design Blog : Replacing images with Geomet... | Qlik Community

Re: Different Colors for Different Conditions

300sss300 — Wed, 25 May 2016 07:29:08 GMT

Suppose the data is as follows:

Date Values Var $ VAR %

Jan-15 100

Feb-15 120

Mar-15 140

Jan-16 80 -20 -20%

Feb-16 160 40 33%

Mar-16 65 -75 -54%

In Qlik I have only 2 fields Date and Values Variation is calculated by using Above (Sum) Formula.

Now Bar Chart containing Above Sum Expression is showing variation but in same color.

What I need is that Same Bar Chart showing variations for Jan 16 to Mar 16 should show Red color for Jan 16 and mar16 and Green color for Feb 16

stalwar1‌

Re: Different Colors for Different Conditions

300sss300 — Wed, 25 May 2016 07:38:30 GMT

Thanks!

Can you please give real time example for If(YourExpression >0,LightGreen(),LightRed())

Lets say I have bar chart with expression Sum(Sales) - Above (Sum(Sales))

How to use this expression and where???

Best Regards,

Re: Different Colors for Different Conditions

300sss300 — Wed, 25 May 2016 07:38:57 GMT

Thanks !

Re: Different Colors for Different Conditions

tamilarasu — Wed, 25 May 2016 07:54:41 GMT

Check the below link for example.

Is it possible to change colour of bar chart depending if +ve or -ve? (QV v8.5)

Re: Different Colors for Different Conditions

brunobertels — Wed, 25 May 2016 08:13:29 GMT

In a strait table for the mesure who calculate the variance

for example like this

i have dimension week

cells from last year , cells from current years and the difference between weeks

the difference has a specific format with an arrow and color depending of positive or negative variance.

in Qlik Sense select for format mesure specific :

and add this format :

▲ ###0;▼ ###0

then in the color expression panel add your color mesure

for example for me my color mesure is

if(

Count({$<[Resultat Rapport Rdv]={'Vendu'},[Statut organisme au moment de l'appel]-={'Client'}>}[Resultat Rapport Rdv])

rangesum(above(Count({$<[Resultat Rapport Rdv]={'Vendu'},[Statut organisme au moment de l'appel]-={'Client'}>}[Resultat Rapport Rdv]),1,1))>0

,rgb(0, 255, 110),rgb(255, 0, 34))

hope it helps