Understanding how a qlickview app works ?

[#1]

I saw a post which explains how to do a slideshow in Qlikview. It works properly, but I am not able to figure out how it really works.

I thought of looking at a couple of places real quick to figure it out, but could not understand it -

- Qlikview > Settings > Expression overview

- Qlikview > Settings > Variable overview

- Script editor.

Can you help me to understand how it works ? Are there any other places that I need to look at in order to be able to figure out

how this app (or any other qlikview app for that matter) works ?

Thanks.

[shree909]

Hi,

This app works on the seconds of the time.

if the seconds of the time fall between 1 and 10 it will be main sheet.

1) created a variable  which can be seen in variable overview.

2) go to Document properties and select the sheets .

when u select  the sheet and look for properties u will see the condition.

3) If u select the sheet properties also u will find the conditions

Thanks

[MK_QSL · Accepted solution]

There is a variable defined for this document.

Variable Name

Act

Definition

=left(right(Now(),5),2)

This variable will give you seconds from current time i.e. NOW()

Now if you go to sheet properties, you can see that there is a condition for Show Sheet for each sheet.

Let's consider the Main sheet.

The condition is

Act >=0 and Act <= 10

i.e This sheet is only visible if seconds from current time is between 0 to 10

similarly

Sheet 1 is visible for Act >=11 and Act <= 20 i.e seconds between 11 to 20 seconds.

If you want all sheet and their conditional show expression,

go to Settings >> document properties >> security tab >> Select SHOW ALL SHEETs and OBJECTS...

Hope this helps...

[#4]

Perfect. Crystal clear. Thank you.