topic Re: Change Line Style if current dimension is current hour in QlikView

Change Line Style if current dimension is current hour

Anonymous — Tue, 17 Sep 2013 22:30:05 GMT

My line chart displays the volume of incoming phone calls received at the call center over the hours (00:00 - 23:59) of the current day. I want to change the line style from the last hour to the current hour (it is now 6:32p so I would like the line from 17:00 - 18:00 to be dashed or something other than a solid)

Dimension: Hour(Incoming_Call_Time)

Expression: Count(Distinct(Call_ID))

I figured the below would work but no luck. I used ReloadTime() because the data is refreshed every 15 minutes.

=if(Hour(Incoming_Call_Time)=Hour(ReloadTime()),'<s2>','<s1>')

Re: Change Line Style if current dimension is current hour

MayilVahanan — Tue, 17 Sep 2013 22:42:25 GMT

I think, ReloadTime() hour is not match with hour(Incoming_call_Time).

Can you provide a sample for that?

Re: Change Line Style if current dimension is current hour

Anonymous — Tue, 17 Sep 2013 23:13:30 GMT

I can spend some time tomorrow tossing together a sample.

I tested to make sure ReloadTime() was working by modifying my count expression to only count calls if Hour(Incoming_Call_Time) < Hour(ReloadTime()). The line chart changed and removed calls originating in the 18th hour (6p)

Re: Change Line Style if current dimension is current hour

marcel_olmo — Wed, 11 Dec 2013 11:15:58 GMT

Hey Nick, I want to do the same, if one condition is accomplished, change the line style, otherwise not.

Have you found a way to do it?

Regards, Marcel.

Re: Change Line Style if current dimension is current hour

annafuksa1 — Wed, 11 Dec 2013 11:28:39 GMT

Please see attachment and tell me is it help

Re: Change Line Style if current dimension is current hour

marcel_olmo — Wed, 11 Dec 2013 22:12:49 GMT

Thanks Anna! That was it! Regards, Marcel.