topic Re: Understanding how a qlickview app works ? in QlikView

Understanding how a qlickview app works ?

Thu, 17 Apr 2014 22:57:51 GMT

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 — Thu, 17 Apr 2014 23:07:05 GMT

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 — Thu, 17 Apr 2014 23:10:25 GMT

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

Thu, 17 Apr 2014 23:56:02 GMT

Perfect. Crystal clear. Thank you.