Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
rustyfishbones
Master II
Master II

Expression Issue

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

2017-09-28_1614.png

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?

12 Replies
sunny_talwar

Great

rustyfishbones
Master II
Master II
Author

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.

2017-09-28_1746.png

sunny_talwar

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