Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Understanding how a qlickview app works ?

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.

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

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...

View solution in original post

3 Replies
shree909
Partner - Specialist II
Partner - Specialist II

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
MVP
MVP

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...

Not applicable
Author

Perfect. Crystal clear. Thank you.