Solved: Re: Dynamic Sheet - Page 2 - Qlik Community

pgalvezt · ‎2011-03-28

Hi all,

I need some help with this. I have 5 Sheets on my Qlikview document and what I want is to change each sheet each 30 seconds, Can you help me with this. I tried with the example here in the qlikview web (Dynamic Sheets = the sheet turn every 10 seconds), but I cant get results. If Anybody can help me with this... Thanks in advance...

pgalvezt · ‎2011-03-30

It is a very good exercise and thank all of you.

Report Inappropriate Content · ‎2012-11-15

Gentlmen,

Thank you for the great information. I am running into an issue with my tv dashboard display auto switching between tabs. The auto switching works in the desktop client but I am unable to get the tabs to switch in a browser.

If I click the browser screen, the tab will count down and switch if I keep clicking but it will not switch on its own. I am running my dashboard in a Chrome browser on a large tv screen. If I run the dashboard in Internet Explorer it stil does not work and requires me to continuously click the screen for it to switch tabs.

Can someine provide some guidance?

Thanks,

Rob

Anonymous · ‎2013-03-28

I copied the C:\Program Files\QlikView\Server\QlikViewClients\QlikViewAjax\opendoc.htm file and called it OpenDocNoToolbar.htm.

I then replaced the HTML with the following...

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

</head>

<span class="ctx-menu-text">Close</span>

</a>

</li>

</ul>

<span class="ctx-menu-text">Loading...</span>

</div>

</div>

var qva;

function Init() {

var doc = Qva.ExtractProperty("document", null);

var re = new RegExp("^(//[^:/]+(?::\\d+)?/)?([^#]+)");

var segm = re.exec(doc);

doc = segm && segm[2];

var invite = Qva.ExtractProperty("invite", null);

if(invite) doc = "";

if(doc != null) {

qva = new Qva.PageBinding();

qva.View = doc;

qva.Autoview = "";

qva.ShowDocumentTitle = true;

qva.AuthenticateUrl = '/QvAjaxZfc/Authenticate.aspx';

new Qva.Modal();

new Qva.Scanner(qva);

qva.AutoViewAppend (null, qva.DefaultScope, 'servercontrol');

new Qva.Collaboration(qva, document.getElementById("MainContainer"));

Qva.DragDrop.DropDefault = {

'Inside': function(pos, type) {

if (type == 'Field' || type == 'Dimension' || type == 'ObjectType') {

return { 'Element': 'Document.ActiveSheet' };

} else if (type == 'Object') {

return { 'Element': 'Document.ActiveSheet', 'Dialog': 'Drop.qvpp' };

} else {

return null;

}

};

new Qva.Extensions(qva);

qva.AddManager({

'Name': qva.DefaultScope + ".Modal",

'Paint': function (mode, node) {

var width = parseInt(node.getAttribute('width'));

var height = parseInt(node.getAttribute('height'));

var name = node.getAttribute('value');

var url = Qva.Remote + '?public=only&name=' + escape(name) + '.htm';

var params = node.getElementsByTagName("param");

for(var i = 0; i < params.length; ++i) {

var key = params.getAttribute("key");

var value = params.getAttribute("value");

url += "&" + escape(key) + "=" + escape(value);

}

Qva.Modal.instance.Show(qva, url, width, height, true, "QvModal_SessionCollaboration");

}

});

qva._Send("add", "Document.ActiveSheet", false);

} else {

alert("No Document");

}

Qva.SetContextMenu (document, function(event) { return qva.OnContextMenu(event); });

Qva.Start();

}

function CloseSession() {

document.body.style.background = "";

$('#MainContainer, #Tabrow, #QvAjaxToolbar > ul:last').html("");

$('body > script').nextAll().remove();

qva.Enabled = false;

qva.Ready = function () {};

qva.OnContextMenu = function () {};

qva.SendClose();

var $closebtn = $('#Close');

if ($closebtn.length) {

$closebtn.find('.ctx-menu-text').text($closebtn[0].RestoreText || "Restore").end().show()[0].href = 'javascript:RestoreSession()';

}

function RestoreSession() {

window.location = window.location;

}

function Assert(exp, message) {

if (!exp) {

if(message) { alert(message); }

debugger;

}

return exp;

}

if (typeof(Qva.Mgr) === "undefined") {

Qva.GetDebugFiles(Init);

} else { Init(); }

</script>

</body>

</html>

Then for the Document/s you want to remove the tool bar add the URL as below -

When you access the document through the client browser you should see the OpenDocNoToolbar.htm is in the URL.

By doing this it removed the Tool Bar and Close button.

I also wanted my Document to automatically scroll through each sheet every minute, as the Document was to be shown on a TV screen in the office. You can do this using the Show Sheet Conditional on the Sheet Properties.

Create a variable called vShow and then use an expression to give the variable a value. For instance, my document has 5 sheets and I wanted to show each sheet for 1 minute, so my expression looked like this...

=if(right(time( now(),'m'),1)=1 or right(time( now(),'m'),1)=6 ,1,

if(right(time( now(),'m'),1)=2 or right(time( now(),'m'),1)=7 ,2,

if(right(time( now(),'m'),1)=3 or right(time( now(),'m'),1)=8 ,3,

if(right(time( now(),'m'),1)=4 or right(time( now(),'m'),1)=9 ,4,

if(right(time( now(),'m'),1)=0 or right(time( now(),'m'),1)=5 ,5)))))

So my vShow value would either be 1,2,3,4 or 5 depending on the current minute. You can use any expresion that suits the number of sheets you have and the frequency you want to show them.

For each sheet then update the Conditional value i.e. Sheet 1 would be vShow=1, sheet 2 vShow=2 etc

Now everyminute the sheet should change automatically. If you need to make changes to sheets just change the vShow expression to the sheet number you want to see - this saves you having to wait for the document to go through all the sheets.

For me the browser didn't automatically scroll through each sheet, so I installed Easy Auto Refresh for Chrome which lets you specify how many seconds between each browser refresh. Now I can run the browser in full-screen mode, sit back and watch it scroll through each sheet every minute.

Report Inappropriate Content · ‎2013-10-29

Hello Jonathan,

I am having two buttons on the welcome page "ManualMode" and "SlideShow"
I am using the same concept which you have shown. The problem I am facing is whatever the value of vShow is at the time I click SlideShow it goes to that page. For eg if the value of the vShow variable was 4 when I clicked Slideshow button it goes to the 4th tab. Infact I want to always start with the 2nd tab when I click on slideShow.

Please Help....

mr_ramshini · ‎2015-03-07

Hi

I want switch between pages automatically

But i dont know do

Please help me

mr_ramshini · ‎2015-03-07

HI

I have 3 sheets in qlik view

and i want switch automatically between sheets

please help me

thanks

mr_ramshini · ‎2015-03-08

HI

I have a problem

I have a project with 3 sheets and i want show sheets after together automatically

I want show sheet1 after 2 second show sheet2

But i do'nt know do it

Please Help Me

mr_ramshini · ‎2015-03-08

Hi

I have a project in qlik view that have a 3 sheet

and i want go of sheet1 to sheet2 automatically after 2 second

please help me

Thanks

Report Inappropriate Content · ‎2015-05-05

Hi,

I have the dynamic sheet solution that is described by Jonathan above. Unfortunately this solution leads to that the nonactive sheets are not visible in the tabrow. I have like 10 sheets to rotate and from time to time i want to manually activate one of them. Is that somehow possible? Thanks!

mohammadkhatimi · ‎2015-05-06

Hie Jonathan,

Its not working on Accesspoint

Kindly give the solution for working on Accesspoint

Regards,

Mohammad