Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Valued Contributor III

Nee help

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,

Tags (2)
4 Replies
Highlighted

Re: Nee help

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())))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted

Re: Nee help

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())))



Highlighted
Valued Contributor III

Re: Nee help

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,     

Highlighted

Re: Nee help

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