topic Re: Expression Issue in QlikView

Expression Issue

rustyfishbones — Thu, 28 Sep 2017 15:22:17 GMT

Hi All,

I have the following expression.

IF(INTERVAL($(vTest1) - above(above(above($(vTest1) ))),'s.f') > $(InitTime), INTERVAL($(vTest1) - above(above(above($(vTest1) ))),'s.f'), LogFile)

This returns a number for the time difference between transactions, so for one example it returns 3.6 (3.6 Seconds) otherwise it returns the string from the log file - which is working ok

The problem I have is that it returns all times, even though my variable $(InitTime) is set to 0.5, So I should not see 0.4, but I am seeing times less than my Variable any ideas?

Re: Expression Issue

sunny_talwar — Thu, 28 Sep 2017 15:26:47 GMT

Where do you seen 0.4 in the image?

Re: Expression Issue

rustyfishbones — Thu, 28 Sep 2017 15:30:39 GMT

It's further down the chart, here is the image scrolled down

Re: Expression Issue

rustyfishbones — Thu, 28 Sep 2017 15:32:00 GMT

If the time is less than 0.5 then green otherwise red for the line plus the 3 lines above

Re: Expression Issue

rustyfishbones — Thu, 28 Sep 2017 16:09:00 GMT

Hi Sunny, I know what the issue is

if I type the following expression

TIME(0.00000579,'hh:mm:ss.fff') it returns 00:00:00.500.

I am setting my variable to be .5 (500 Milliseconds), so I need to convert 0.5 back to Milliseconds

I will try that now.

Re: Expression Issue

sunny_talwar — Thu, 28 Sep 2017 16:12:32 GMT

Try this

IF(INTERVAL($(vTest1) - above(above(above($(vTest1) ))),'s.f') > Interval#($(InitTime)*2, 's')/2,

INTERVAL($(vTest1) - above(above(above($(vTest1) ))),'s.f'), LogFile)

Re: Expression Issue

sunny_talwar — Thu, 28 Sep 2017 16:15:34 GMT

Or this

IF(INTERVAL($(vTest1) - above(above(above($(vTest1) ))),'s.f') > Interval#($(InitTime), 's.f'),

INTERVAL($(vTest1) - above(above(above($(vTest1) ))),'s.f'), LogFile)

Re: Expression Issue

rustyfishbones — Thu, 28 Sep 2017 16:22:23 GMT

No that does not return the correct result.

I need to convert 0.5 to seconds, as Qlikview treats this as 12:00:00.000,

If I set my variable to 0.00000579, it works perfectly, but I want to convert 0.5's as a number

Re: Expression Issue

sunny_talwar — Thu, 28 Sep 2017 16:30:19 GMT

That is what it should be doing... this give me

=Num(Interval#(0.5, 's.f'))

this

Replace 0.5 with your variable and it should work (I think)

Re: Expression Issue

rustyfishbones — Thu, 28 Sep 2017 16:39:02 GMT

Sorry it's working thanks

Re: Expression Issue

sunny_talwar — Thu, 28 Sep 2017 16:40:16 GMT

Great

Re: Expression Issue

rustyfishbones — Thu, 28 Sep 2017 16:47:27 GMT

Hi Sunny,

Do you think I can color the 3 lines above it too, So each time my line is RED, i want the previous 3 lines to be red also.

Re: Expression Issue

sunny_talwar — Thu, 28 Sep 2017 17:00:01 GMT

It should be possible using Above()/Below() functions... but it will have to tested out... Difficult to give an expression without taking a look