Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Chart conditional colour formatting

I am attempting to have a default bar chart coloured.

When a User initially opens the Dashboard, the SLA Entire Risk Engine batch details will appear and where minutes are negative, bars should be red and where minutes are positive bars should be green (will change colour for colour blind people another time).

The code works fine if I don't use a default selection but when I introduce a default selection the positive minutes red instead of green.

If((isnull(Milestone) AND Min({<System={'Source'},Milestone={'Entire Risk Engine batch'},Status={'Breach'}>} Minutes))<0,

    rgb(255,110,110),

If((isnull(Milestone) AND Max({<System={'Source'},Milestone={'Entire Risk Engine batch'},Status={'Breach'}>} Minutes))>0,

    Green(),

If(Min({<System={'Source'},Status={'Breach'}>} Minutes)<0,   

    rgb(255,110,110),

    Green(),

    )))

Capture.PNG

25 Replies
Anonymous
Not applicable
Author

the problem with that is it actually gets rid of the zero values that are not meant to be excluded

Ralf_Heukäufer
Partner - Creator III
Partner - Creator III

Hello Cameron,

Use this in your Dimension as Date:

= if (isExclusion=0 and Minutes<>0, date(Date, 'WWW DD-MMM-YY'))

sunny_talwar

Does it help to uncheck ' Include zero Values'?

Capture.PNG

Ralf_Heukäufer
Partner - Creator III
Partner - Creator III

Have you tried

= if (isExclusion=0 and Minutes<>0, date(Date, 'WWW DD-MMM-YY'))

as Dimension?

Anonymous
Not applicable
Author

Hi, I have just found another issue before I try this. Tue 14-Nov and Wed 15-Nov are not zero refer above image from Nov 17, 2017 10:42 AM . Tue should be 1 and Wed should be 5 minutes. I dont know why.

Capture.PNG

Anonymous
Not applicable
Author

As mentioned below, there should not be any 0 minutes for Tue 14-Nov and Wed 15-Nov. I found that by checking off the zeroes that certain dates were then not appearing. Not sure why we have zeroes instead of numbers.

Anonymous
Not applicable
Author

The Raw Data tab has the Total = to 0 but the details are at least 1 or above. That looks very odd!

Ralf_Heukäufer
Partner - Creator III
Partner - Creator III

I think your Date assignment to your timestamps doesn´t work correct you can see it here:

I select 15.11.2017 but it shows 16.11.2017

Anonymous
Not applicable
Author

what happens is that the SLA commences on the 15th but most of the activity occurs during the morning of the 16th

Ralf_Heukäufer
Partner - Creator III
Partner - Creator III

If you try my solution it look like your description

Additional you can deselct the the show zero values field.