topic Re: Help with Variable in QlikView

Help with Variable

pkelly — Mon, 28 Oct 2013 20:10:33 GMT

We have a large TV in our Sales Office which runs a single report with 7 sheets…

The sheets rotate by utilising the show sheet conditional option and a variable (varReportView) e.g. varReportView='1'

The variable is set using the following which is basically a 2 minute loop….

=IF(Odd(Minute(now())) = 0 AND Second(now()) >= 0 AND Second(now())= 20 AND Second(now())= 40 AND Second(now())0 AND Second(now()) >= 0 AND Second(now())0 AND Second(now()) >= 15 AND Second(now())0 AND Second(now()) >= 30 AND Second(now())0 AND Second(now()) >= 46 AND Second(now())

We want to add more sheets to the report and need to now look at increasing this loop to three minutes…

Any suggestions on how I could achieve this?

Re: Help with Variable

swuehl — Mon, 28 Oct 2013 20:46:49 GMT

I think you got a copy&paste issue here, your expression is not syntactically correct.

I also don't understand why you use Second(now()) = 20 and Second(now()) = 40, since this is never true.

Re: Help with Variable

pkelly — Tue, 29 Oct 2013 07:59:50 GMT

Thanks swuehl - yes something has gone wrong with copy and paste - am having issues posting to the forum from my browser - will upload a sample application...

Re: Re: Help with Variable

pkelly — Tue, 29 Oct 2013 08:14:03 GMT

Please find attached example application....

Re: Re: Re: Help with Variable

swuehl — Tue, 29 Oct 2013 09:47:22 GMT

You can use Mod() function instead odd() / even().

Re: Help with Variable

pkelly — Tue, 29 Oct 2013 10:00:01 GMT

Thank you...spot on...