topic Re: Colour in QlikView

Colour

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi ALl,

I want to set the colour and iam doing this under the expression then background

I have 4 classes .

Class A

Class B

Class C

Class D

And i want to show that if the countt of ticket for Class A and B is not equal to 0 and the Days are within 0to7 days then red else it should be Green

and if the the count of Ticket for Class A and Class B are are greater than 5 and the days are 8 to 20 then Red else Green

if Count of ticket is above of 10 for class A and Class B for the days above 20 then it should be AMber else Green..

Iam trying to use this formula but this is not working ..

Can someone please sugget me on this

if(count({<Class={'Class A','Class B'},Days={0 -7}>}Ticket)<>0,Red(),Green())

please need help of the expertise....

Thanks in advace....

Re: Colour

Anil_Babu_Samineni — Tue, 19 Sep 2017 04:22:47 GMT

Not sure, How 0-7 is the single repository.

May be any one of these?

if(count({<Class={'Class A','Class B'},Days={'0 -7'}>}Ticket)<>0,Red(),Green()) //I assume you have direct days wither in bucket..

if(count({<Class={'Class A','Class B'},Days={"=Days >=0 and Days <=7"}>}Ticket)<>0,Red(),Green())

Re: Colour

smilingjohn — Tue, 19 Sep 2017 04:42:56 GMT

Hi Anil.

SHould i use 'and' after the end of this Expression for 8 to 20 and so on

Re: Colour

Anil_Babu_Samineni — Tue, 19 Sep 2017 04:45:00 GMT

Why not?

if(count({<Class={'Class A','Class B'},Days={'0 -7', '8-20'}>}Ticket)<>0,Red(),Green())

Re: Colour

smilingjohn — Tue, 19 Sep 2017 04:53:43 GMT

hi Anil ,

Please check if I am using the write expression

=if(count({<Class={'Class 1','Class 2'},Days={"=Days >=0 and Days <=7"}>}Ticket)<>0,Red(),Green()) and

if(count({<Class={'Class 1','Class 2'},Days={"=Days >7 and Days <=14"}>}Ticket)>=5,Red(),Green()) and

if(count({<Class={'Class 1','Class 2'},Days={"=Days >14 and Days <=20"}>}Ticket)>=7,Blue(),Green()) and

if(count({<Class={'Class 1','Class 2'},Days={"=Days >20"}>}Ticket)>=10,Blue(),Green())

Thanks

Re: Colour

jonathandienst — Tue, 19 Sep 2017 04:54:05 GMT

Are these 3 separate colour selections? If so, then:

=If(Count({<Class = {'Class A', 'Class B'}, Days = {">=0 <=7"}>} Ticket) > 0, Red(), Green())

=If(Count({<Class = {'Class A', 'Class B'}, Days = {">=8 <=20"}>} Ticket) > 5, Red(), Green())

=If(Count({<Class = {'Class A', 'Class B'}, Days = {">20"}>} Ticket) > 10, Amber(), Green())

Re: Colour

jonathandienst — Tue, 19 Sep 2017 04:56:28 GMT

If it's one combined expression, then

=If(Count({<Class = {'Class A', 'Class B'}, Days = {">=0 <=7"}>} Ticket) > 0, Red(),

If(Count({<Class = {'Class A', 'Class B'}, Days = {">=8 <=20"}>} Ticket) > 5, Red(),

If(Count({<Class = {'Class A', 'Class B'}, Days = {">20"}>} Ticket) > 10, Amber(), Green())))

(Based on your original post)

Re: Colour

Anil_Babu_Samineni — Tue, 19 Sep 2017 04:58:45 GMT

How about this?

=If(Count({<Class = {'Class A', 'Class B'}, Days = {">=0 <=7"}>} Ticket) > 0, Red(),

If(Count({<Class = {'Class A', 'Class B'}, Days = {">=8 <=20"}>} Ticket) > 5, Red(),

If(Count({<Class = {'Class A', 'Class B'}, Days = {">20"}>} Ticket) > 10, Blue(), Green())))

Re: Colour

smilingjohn — Tue, 19 Sep 2017 05:12:18 GMT

Hi Jonathan,

It is giving me the erorr of Set modifiers

Re: Colour

smilingjohn — Tue, 19 Sep 2017 05:37:48 GMT

Hi Anil

This works

BUt now i want to add RGB(255,194,0), instead of blue..

it shows red mark as error

Re: Colour

Anil_Babu_Samineni — Tue, 19 Sep 2017 05:40:03 GMT

It should like below?

=If(Count({<Class = {'Class A', 'Class B'}, Days = {">=0 <=7"}>} Ticket) > 0, Red(),

If(Count({<Class = {'Class A', 'Class B'}, Days = {">=8 <=20"}>} Ticket) > 5, Red(),

If(Count({<Class = {'Class A', 'Class B'}, Days = {">20"}>} Ticket) > 10, RGB(255,194,0), Green())))