Time based coloring of text object . How to achieve it ?

[shekhar_analyti]

Hi All ,

I have a scenario where in i want to get the text objects colored based on time . I will try to explain with example .

Requirement is  :

1) when user presses A then

2) exactly after 4 seconds , color of B should be green and once B is green

3) then exactly after 2 seconds C should get Yellow colored .

4) Once C is colored then only navigation to next sheet should happen.

Note : All these objects are in sheet 1 .

If user navigates back to sheet 1 then again above sets of actions should be performed to navigate to next sheet .

Thanks & Regards

Shekar

[sunny_talwar]

I agree that this is probably not a good idea to use Now(), but I was just curious why it doesn't work on AccessPoint... Thanks for your response though

[shekhar_analyti]

Hi Peter ,

Please explain this ;

IF(NOW() > (Click1 + 4/60/60/24), GREEN())

I just wanted to make it 1 second instead of 4 .

Thanks & Regards

Shekhar

[sunny_talwar]

Just change the 4 to 1

IF(NOW() > (Click1 + 1/60/60/24), GREEN())

[shekhar_analyti]

  ... Still help me understand 1/60/60/24

[sunny_talwar]

Usually QlikView read 1 as a day... to convert this into a second, you can divide it by 24 hours in a day * 60 minutes in a hour * 60 seconds in a minute... 1/(24*60*60) = 1 second