Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a doubt regarding transfer of state between qlikview documents.
I have multiple qlik view documents.All the drilldown details are summarized into one document.
So, on going to the drilldown document, is it possible to go back to the document that called it?
I tried it using variables.But the value is null in the drilldown document even after checking Transfer state.
I bellieve checking this only retains variable values between sheets of the same document and not between documents.
Is there any method to do this?
Regards,
Anju
Hi,
From Qlikview help file.
Mark the check box Transfer State to transfer the selections from the original document to the one you wish to open. The opened document will first be cleared of selections.
Mark Apply state on top of current to retain the second document’s selections and apply the original document’s selections on top of them.
Hope attached files helps you in understanding this. Download this files into the same folder and open Test.qvw and select some items and then click the button to open test1.qvw file.
The selections which you are made in the test.qvw will be available in test1.qvw.
Regards,
Jagan.
Hi Jagan,
I tried with the files you provided but somehow I feel like it works only for the first time.
Things to do:
Make a button in (test1) which will navigate you back to (test).
Now, select some values in (test) and then go to (test1) ::::: here the selected values will be passed to (test1)---as expected.
Change the selected values in (test1) and then navigate to (test):::: its not working as expected..Even if I clear all the selections from both the files. Why?
Plz reply if you have any solution to the above mentioned problem.
Regards
Sagar Gupta
Hi Jagan,
Does this work on the access point?
Any special settings required?
regards,
Rajesh Vaswani
Not sure. But it should work atleast in IE Plugin.
Regards,
jagan.
Hi Jagan,
I have the same question as asked by Sagar.
Could you please help
Hi Ankita,
This will definitely work did you tried?
Regards,
Jagan.
Hi Jagan,
Yes it works for me.
My another question is:
Suppose, I have Id column (Listbox) in application 1 and 2. In application 2 I select Id# 2 and save it and close it. (Means Application 2 has current selection as Id# 2)
Now when I make selection in Application 1 as Id#1 and check the apply state on top of current selection and on the button click open the application 2, Id in application 2 does not retain 2 as selection , rather 1 is selected.
So, what is the use of the option Apply state on top of current selection. Hope I'm clear.
Thanks & Regards,
Ankita
Hi Ankita,
If you select Apply state on top of current selection it will select the current selections in the new dashboard replacing the existing the selections. If you don't select that option Dashboard will load with default selections.
Regards,
Jagan.
Opening Qlikview document, with Transfer state and Apply state is working as expected, but it is true, it is not updating variables content !
For this you need to add a run macro action to your button and write a very small macro that will record in a file some of your variables values that need to be updated in the other document.
With the other document, add an open document trigger, to run a macro that will read the file (if it exists), and update the variables based on the value stored in that file ... that works fine.