Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to create a new in qlikview file to open an another new .qvw file, once I click on the sheet tab.
lets say, I have 5 sheets in the current file, whenever I click on the last sheet tab, it has to open a new qlikview file.
plz help me...
thanks..
Hi,
Here is the macro which will create a new sheet for you.
Sub Create_tab
set newsheet=ActiveDocument.CreateSheet
set sp=newsheet.GetProperties
sp.Name="New Tab"
newsheet.setProperties sp
newsheet.Activate
End
Place this at Macro editor ( Just predd Ctrl + m)
Copy and paste the macro here.
Once pasted just click on "Check"
Now go to last sheet -> Right click and go to properties of last sheet
Go to triggers
Click on Add Actions under the OnActivateSheet
Once clicked go to External -> Macro
And type the Create_tab
Click ok
Now go to last sheet, a new sheet will be created for you.
Regards,
Kaushik Solanki
In Properties -> Triggers you should be able to add an external event whic opens another QlikView document.
Yes I saw that,
In
Actions>External>Open Qlikview Document..
it asks for document, here is my question how to give my desired document here?
lets say my document is in 'c:/Documents and Settings/QV/newQV.qvw' location.
I tried giving 'c:/Documents and Settings/QV/newQV.qvw' but it didnt open. pls let me know how can i do that correctly....
It might be easier if you just add the command as an action to a number of different text-objects .... that will work.
Hi,
Yes you can open a different Qlikview Applications from the different location from single Qlikview application. See the attached sample for demo just try and create a folder in locations like "D:\Test Folder 1\App1.qvw" "and D:\Test Folder 2\App2.qvw" and try it.
Hope this helps you.
Regards,
Anand
Hi,
Here is the macro which will create a new sheet for you.
Sub Create_tab
set newsheet=ActiveDocument.CreateSheet
set sp=newsheet.GetProperties
sp.Name="New Tab"
newsheet.setProperties sp
newsheet.Activate
End
Place this at Macro editor ( Just predd Ctrl + m)
Copy and paste the macro here.
Once pasted just click on "Check"
Now go to last sheet -> Right click and go to properties of last sheet
Go to triggers
Click on Add Actions under the OnActivateSheet
Once clicked go to External -> Macro
And type the Create_tab
Click ok
Now go to last sheet, a new sheet will be created for you.
Regards,
Kaushik Solanki
Thank you Anand, but my requirement is without using any button.
ex. I have 2 .qvw files A & B... In A i have 3 sheets, wenever i click to open the 3rd sheet in A, It should trigger B.qvw file with in the same or different window, without using any button...
Hi,
For this. Goto the sheet properties (Last Sheet of A Qvw)
Click on OnActivateSheet -> Add Action -> External -> Open Qlikview Application
Pass the Full path with filename and extension.
Also click on open in same window.
Regards,
Kaushik Solanki
Kaushik, its working if i try with Button, but not this way.. i don't know why, guess somewhere we are going wrong...
Hi,
Use this macro code in On Active Sheet trigger in sheet properties.
Mention the full path if the Qvw file is not in the same folder.
Sub OpenHome
set App=ActiveDocument.GetApplication
App.OpenDoc "Home.qvw","",""
ActiveDocument.Save
ActiveDocument.CloseDoc
End Sub
Let me know it is fine or not.
Regards...