topic [ASK] how to make auto show-hide sheet in QlikView

[ASK] how to make auto show-hide sheet

Mon, 16 Dec 2013 08:13:36 GMT

Hello qlikviewer..

I have a task to make sheet show and hide automatically

I have 4 sheet (a, b, c, d)

And everysheet will show for 5 second and then hide, then go to next shet for 5 second and then hide, and on and on..

How to make that?

Many thx...

Re: [ASK] how to make auto show-hide sheet

tresB — Mon, 16 Dec 2013 08:21:48 GMT

Have a look here:

Automatic switching of sheets

Re: [ASK] how to make auto show-hide sheet

Anonymous — Mon, 16 Dec 2013 08:23:45 GMT

In sheet properties>> Layout tab>> in show conditional , use following expressions.

for sheet a

if(mod(second(now()),20)>0 and mod(second(now()),20)<=5,1,0)

for sheet b

if(mod(second(now()),20)>5 and mod(second(now()),20)<=10,1,0)

for sheet a

if(mod(second(now()),20)>10 and mod(second(now()),20)<=15,1,0)

for sheet a

if(mod(second(now()),20)>15 and mod(second(now()),20)<=20,1,0)

Hope it will help you out

Regards

Nitin

Re: [ASK] how to make auto show-hide sheet

Mon, 16 Dec 2013 08:27:08 GMT

Hi,

In this thread you will find a good working solution from John Witherspoon

http://community.qlik.com/message/96051#96051

It is working fine I have an app based on his solution running all the time.

regards,

Gerrit

Re: [ASK] how to make auto show-hide sheet

Mon, 16 Dec 2013 08:33:48 GMT

I prefer not using macro for this

And I will try nitin solution

Many thx nitin, and other qlikviewer

Re: [ASK] how to make auto show-hide sheet

Tue, 17 Dec 2013 17:14:31 GMT

i have worked with these in some time and take a conclution,

the formula that nitin gave only able to use if you have 60 vVarDur

where vVarDur = [total of sheet that you will use] * [duration of each variable to show]

but if you have more than 60 vVarDur, then you maybe need formula like this :

0. Max vVarDur=60*60=3600 (0-3599) //maximal vVarDur that can be used

1. Qlikview variable you need :

1.1. vModSec = mod((minute(now())*60)+Second(now()),vVarDur)

//vVarDur is total of sheet*duration@sheet that you will use

1.2. vModSecMul = [value_number] //duration of each sheet in second

2. Sheet Properties -> Conditional

2.1. =if($(vModSec)>(x*$(vModSecMul)) and $(vModSec)<=(y*$(vModSecMul)),1,0)

//x is the *number of previous sheet, y is the

*number of current sheet

*note :

if current sheet is your first sheet, then x=0 and y=1

if current sheet is your second sheet, then x=1 and y=2

.... and on ...

i hope this'll help

correct me if i'm wrong

many thx for the clue