topic Re: Nee help in QlikView

Nee help

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

Hi all,

I have a bar chart it should show the results as

0-3 days --display green colour

4-6 days --- display yellow

7-9 days ---- display thick yellow

10+ days ------ display red

dimension: type

values are riskprint and riskdevelopment

measure; count of networking days

logic is: I have 3 work flows in between 3days so that 3 should show green colur in one bar and in that 1 project is riskprint blue colur and 2 projects is riskdevelopment red colur

see the attached image,

Re: Nee help

Anil_Babu_Samineni — Sun, 24 Sep 2017 19:02:25 GMT

You may need this?

Create one field in script

Day(DateField) as Day

And then BG color may be this?

If(Day >= 0 and Day <=3, Green(), If(Day >=4 and Day <= 6, Yellow(), If(Day >= 7 and Day <=9, Black(), Red())))

Re: Nee help

its_anandrjs — Sun, 24 Sep 2017 19:40:08 GMT

Try this in the BackColor properties of the chart and if you have any date field just use calculated dimension in the dimension.

Ex:-

=Day(Datefield)

BG Color Properties

If(Day >= 0 and Day <= 3, Green(),

If(Day >= 4 and Day <= 6, rgb(255,255,128),

If(Day >= 7 and Day <= 9, rgb(242,237,45), Red())))

Re: Nee help

soniasweety — Mon, 25 Sep 2017 06:53:10 GMT

but there is one more logic is

which I used as dimension with two values : riskprint and riskdevelopment

for example 0-3 days the result is 3 workflows came so in that three 2 are into riskprint 1 into riskdevlopment

that two show in blue colur and 1 show in red colur,

Re: Nee help

its_anandrjs — Mon, 25 Sep 2017 08:12:39 GMT

Then use the Mapping for the same table and maintain that table for the colors.