topic Re: Second(),odd(),now() in QlikView

Second(),odd(),now()

sn_9052 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Can any one explain the below function,How it execute in qlikview.

I wrote the below code for flashing a Text box background color,but I want to know that functions what it do in that code.

if(Odd(Second(Now(1))),Yellow(),Green()).

Thank You.

Re: Second(),odd(),now()

sunny_talwar — Thu, 17 May 2018 11:01:41 GMT

I think all this is doing is changing the color from Yellow to Green every 2 seconds.

Second() function give the current second and Odd() function checks if the value is Even or Odd.. If it is Odd, then Yellow and When it is Even then it shows Green

Re: Second(),odd(),now()

YoussefBelloum — Thu, 17 May 2018 12:01:18 GMT

unfortunately this will not work in the server/accesspoint

Re: Second(),odd(),now()

sunny_talwar — Thu, 17 May 2018 12:02:22 GMT

Why not?

Re: Second(),odd(),now()

YoussefBelloum — Thu, 17 May 2018 12:04:13 GMT

Because I try it many times, colors will not change periodically on the accesspoint

Re: Second(),odd(),now()

sunny_talwar — Thu, 17 May 2018 12:04:55 GMT

Sense or view? may be related to Now()?

Re: Second(),odd(),now()

YoussefBelloum — Thu, 17 May 2018 12:06:04 GMT

I only try it on Qlikview..

Re: Second(),odd(),now()

sunny_talwar — Thu, 17 May 2018 12:06:39 GMT

Seems to be working okay on access point created object... will try by creating an object before I move it to production

Re: Second(),odd(),now()

YoussefBelloum — Thu, 17 May 2018 12:07:52 GMT

Cool ! let me know

Re: Second(),odd(),now()

YoussefBelloum — Thu, 17 May 2018 12:11:10 GMT

for me, on a created object, it is completely freezing if i don't move the mouse..

Re: Second(),odd(),now()

sunny_talwar — Thu, 17 May 2018 12:16:05 GMT

I just created a document on dev environment and it seems to be working without problems

Re: Second(),odd(),now()

YoussefBelloum — Thu, 17 May 2018 12:30:54 GMT

I made all the tests, I push one test app to the DEV.. the color change only when I click on the mouse..

Qlikview 12.1 SR3

Re: Second(),odd(),now()

sunny_talwar — Thu, 17 May 2018 12:32:43 GMT

Tested on QV11.2 SR5... can test on QV12.1 later in the month....

Re: Second(),odd(),now()

YoussefBelloum — Thu, 17 May 2018 12:37:55 GMT

last year I tried the same on a 11 version, it is exactly the same.. don't change if I don't click on the mouse.

I tried the expression above on the background of a textobject

Re: Second(),odd(),now()

sunny_talwar — Thu, 17 May 2018 12:53:54 GMT

Worked without any issue in a text box color for me. Just copy pasted the expression that the OP provided in there main post

Re: Second(),odd(),now()

sunny_talwar — Thu, 17 May 2018 12:54:15 GMT

No clicking of mouse is needed

Re: Second(),odd(),now()

YoussefBelloum — Thu, 17 May 2018 12:54:58 GMT

so I'll downgrade the server

Re: Second(),odd(),now()

sunny_talwar — Thu, 17 May 2018 12:57:27 GMT

But didn't you say that it didn't work for you on QV11 also?

Re: Second(),odd(),now()

YoussefBelloum — Thu, 17 May 2018 12:58:49 GMT

I'm going down to version 10

Re: Second(),odd(),now()

sunny_talwar — Thu, 17 May 2018 12:59:50 GMT

version 1 will give the best performance....