topic Re: Switch between normal mode and web mode in QlikView

Switch between normal mode and web mode

Mon, 23 Jun 2014 15:51:28 GMT

I am working on a qvw where in first sheet needs to be in normal mode and the second sheet needs to be in web mode because i am showing webpage viewer extension object in second sheet. when we navigate to second sheet it should automatically switch to web mode. is it possible in qlikview through any script or macro or actions.

Thanks in Advance

Hari

Re: Switch between normal mode and web mode

whiteline — Mon, 23 Jun 2014 19:06:38 GMT

Hi.

You can try a macro:

set docprop = ActiveDocument.GetProperties
docprop.UseAjaxUI = true
ActiveDocument.SetProperties docprop

Re: Switch between normal mode and web mode

Tue, 24 Jun 2014 11:53:23 GMT

Hi,

Thanks for your help,

i navigated to sheet properties--->Triggers---->OnActivateSheet------->RunMacro and used your code in the macro.still i am not able to resolve the issue.Could you please help.

Re: Switch between normal mode and web mode

sudeepkm — Tue, 24 Jun 2014 11:57:11 GMT

do you see any issues enabling web view mode for all your sheets?

Re: Switch between normal mode and web mode

whiteline — Tue, 24 Jun 2014 13:16:51 GMT

Hi.

I've checked.

The macro correctly triggers the checkbox in the document properties.

But unfortunately it affects the document view only after reopening.

Re: Switch between normal mode and web mode

Tue, 24 Jun 2014 13:19:43 GMT

Hi,

I had an straight table in the first sheet and i have to select a row from that table and need to set the values from the selected row to variables and needs to pass to the second sheet. and i am not able to select a row from straight table in web mode.

I will use the variables to show in the extension object in the second sheet.As the extension object works only in web mode i need to show the second sheet in web mode.

Thanks,

Hari

Re: Switch between normal mode and web mode

Tue, 24 Jun 2014 13:20:11 GMT

Hi Whiteline

This should work

Regards

Rishi beri

Re: Switch between normal mode and web mode

Tue, 24 Jun 2014 13:45:14 GMT

Hi,

Yes you are right,

i have checked it, but the entire document is opening in web mode , but my requirement is only second sheet has to be in web mode

Re: Switch between normal mode and web mode

vardhancse — Tue, 24 Jun 2014 13:50:22 GMT

Web view extension will be worked only in web mode.

macros will work only in IE plug in mode but not in ajax mode.

Any way under development if we want to see the web viewer then we can change the view to web view.

once published in to the access point, then any way the view will be web view only

Re: Switch between normal mode and web mode

vardhancse — Tue, 24 Jun 2014 13:52:04 GMT

if trigger with macro was created for specific sheet, then only that sheet can we viewed in web view.

Re: Switch between normal mode and web mode

Tue, 24 Jun 2014 14:37:48 GMT

Hi Sasi Vardhan,

Thanks for your response,

I am following the below approach, i am setting action to second sheet.

Settings--->Sheet Properties--->Triggers--->OnActivateSheet--->AddActions--->Run Macro--->

macro code:

set docprop = ActiveDocument.GetProperties

docprop.UseAjaxUI = true

ActiveDocument.SetProperties docprop

ActiveDocument.DoReload 2, true

But the changes are reflecting for the entire document and not to particular sheet and only when the qvw is closed and opened once again.

Thanks

Hari

Re: Switch between normal mode and web mode

Wed, 29 Jun 2016 12:32:00 GMT

Hi Hari,

It's a bit of a hack, but there is a way to automatically activate the WebView for individual tabs by emulating the necessary key strokes via a macro.

The macro code looks like this:

sub toggleWebMode
    Dim WshShell
   
    Set WshShell = CreateObject("wscript.Shell")
    WshShell.SendKeys "%(V) U" 'Simulate Alt+V U
end sub

Simply add the macro to both the OnActivateSheet and OnLeaveSheet triggers for the WebView sheets, and you should be good to go.

This will not work if the QlikView interface language is not set to English (in this case, you'll need to adjust the SendKeys commands).

Also, if the user happened to be pressing a key while switching to the sheet, it might cause the activation of the WebView to fail.