topic Straight Chart Colour Expression in QlikView

Straight Chart Colour Expression

Wed, 19 Dec 2012 15:13:58 GMT

Hi,

I have a straight chart which show data per criteria. However I have a field called Last Action which is a calculated field.

On the Straight chart is there a way that I can write an expression so if the Last Action is more than 20 Hours, then on the table it shows a red, while everything under 20 hours is white?

Regards,

Jon Ditchfield

P.S. The calculated field for Last Action is below:

=if(call_status_full = 'Pending' or call_status_full = 'Unaccepted' or call_status_full = 'Off Hold' or call_status_full = 'Unassigned',

Interval(

(RangeMin(frac(vJD_TIME), MakeTime(18))

- RangeMax(frac(lastactdate), MakeTime(8)))

+ (NetWorkDays(lastactdate, vJD_TIME-1) * MakeTime(10)) // Only 10 hours per whole day

))

Re: Straight Chart Colour Expression

Anonymous — Wed, 19 Dec 2012 15:19:33 GMT

Jon,

You certainly can. Use attribute expressions for text color, and use your expression for last action, a sort of this:

if(<your expression> >20, red())

Regards,

Michael

Re: Straight Chart Colour Expression

brindlogcool — Wed, 19 Dec 2012 15:25:01 GMT

I understand you want highlight the row in the striaght table when the last action is more than 20 hours.

I would prefer to define the last action and its duration in the edit script as addtional columns.

And you can define the background color of dimension and expression. if you could attach the sample file it would be easier to analyze.

Re: Straight Chart Colour Expression

Wed, 19 Dec 2012 15:33:24 GMT

Hi,

Please find attached a copy of the Qlikview File.

Re: Straight Chart Colour Expression

Anonymous — Wed, 19 Dec 2012 15:44:06 GMT

Use this as expression for background color:

if(
if(call_status_full = 'Pending' or call_status_full = 'Unaccepted' or call_status_full = 'Off Hold' or call_status_full = 'Unassigned',
(          (RangeMin(frac(vJD_TIME), MakeTime(18))
          - RangeMax(frac(lastactdate), MakeTime(8)))
          + (NetWorkDays(lastactdate, vJD_TIME-1) * MakeTime(10)) // Only 10 hours per whole day
))*24

>20, rgb(255,200,200))

Re: Straight Chart Colour Expression

Wed, 19 Dec 2012 15:55:10 GMT

Hi Michael,

I have entered the above expression in the table, under style, background, color, and then pasted into calculated colour, however it all still shows the writing as black.

Re: Straight Chart Colour Expression

brindlogcool — Wed, 19 Dec 2012 15:55:11 GMT

I have added micheal expression in your file and attached it.You can create a variable for the expression and replace the expression with varaible.

Re: Straight Chart Colour Expression

Anonymous — Wed, 19 Dec 2012 16:00:47 GMT

It is in attribute expressions, not style background - see example form brindlogcool.

Regards,

Michael

Re: Straight Chart Colour Expression

Thu, 20 Dec 2012 15:44:56 GMT

Thanks Both, this worked as I wanted it too.