Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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...
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
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...
Perfect. Crystal clear. Thank you.