topic Re: Action: Open QlikView Document in QlikView

Action: Open QlikView Document

sunny_talwar — Thu, 10 Dec 2015 13:01:46 GMT

Hi Friends

I am using Open QlikView Document Action for the first time and had few questions:

How can it be programmed to work on the Desktop version?
Does it work on access point?
If answer to the 2nd questions is yes, then does it still work if you have loop and reduce in both the documents?

I am attaching two sample files for question 1 above.

Thanks in advance for your help and guidance.

Best,

Sunny

Re: Action: Open QlikView Document

sunny_talwar — Thu, 10 Dec 2015 13:05:30 GMT

I guess the first part of the issue got resolved when I changed the file name from 'Something <space> something' to 'Something' (without space)

I would still need help on the question 2 and question 3.

Thanks,

Sunny

Re: Action: Open QlikView Document

avinashelite — Thu, 10 Dec 2015 13:40:06 GMT

Hi Sunny,

As per knowledge yes, the point 2 will work in the access point but you need to have necessary permissions.

Point 3. What do you mean by loops in both documents ? loops in script ? or transfer of selection from one document to other ? if it transfer for state then you have already achieved it in the in the eg

Re: Action: Open QlikView Document

sunny_talwar — Thu, 10 Dec 2015 13:54:18 GMT

For Point 2 -> Would we need a specify the file path or just the file name would be fine since they will be sitting at the same level?

For Point3 -> not the for or while loop, but Loop and Reduce functionality QlikView Security Video Series (5 of 8): Reduce and Loop by NT Username - YouTube

Re: Action: Open QlikView Document

avinashelite — Thu, 10 Dec 2015 14:05:32 GMT

Point 2 : If its in the same folder then its not required... otherwise we need specific the complete the path.

Point 3: If you have security i.e section access implemented using NTNAME then it will surely reduce the data

Re: Action: Open QlikView Document

sunny_talwar — Thu, 10 Dec 2015 14:48:04 GMT

Just confirmed the 2nd bullet point. Now need to work on the last bullet point.

Best,

Sunny

Re: Action: Open QlikView Document

sunny_talwar — Thu, 10 Dec 2015 15:28:37 GMT

Thanks Avinash R‌. I was able to confirm that the third bullet point also works, but with a twist.

Document name needs to be changed to File 2.qvw to ='File 2_' & Only(Dim1) & '.qvw' where the new name on the portal is decided by loop and reduce like this -> %SourceDocumentName%_%DocumentField,Dim1%

So now when I am looking at File 1_A, I can directly open File 2_A and when I am looking at File 1_B, I can open File 2_B.

I hope this to be useful for others in the future.

Best,

Sunny

Re: Action: Open QlikView Document

avinashelite — Fri, 11 Dec 2015 05:29:50 GMT

sunindia Thanks for the updates . I have one question why the we need add the "& Only(Dim1) &" can't we use the transfer the document state option?

Re: Action: Open QlikView Document

sunny_talwar — Fri, 11 Dec 2015 11:25:51 GMT

Avinash -

I am not sure how familiar are you with Loop and Reduce functionality available in QMC. But lets say this is my data:

Dim1 Value

A 40

B 50

and I tell QMC to L&R on Dim1. It will create two files on the access point. Lets say the original qvw was named File.qvw. You will now see these two on access point -> File_A.qvw and File_B.qvw (based on this naming convention %SourceDocumentName%_%DocumentField,Dim1%. This naming convention can be easily configured within QMC). File_A.qvw will only contain data where Dim1 = A and File_B.qvw will only include data where Dim1 = B.

Now coming back to my scenario. I had two Files, File 1 and File 2 and when each of them get L&R, they both will create two files each (in our example of A and B) -> File 1_A.qvw, File 1_B.qvw, File 2_A.qvw & File 2_B.qvw. I was looking for a way to configure the non-L&R version so that I don't have to type File 2_A.qvw and File 2_B.qvw to open them from File 1_A.qvw and File 1_B.qvw, respectively. So instead of hard-coding the A and B, I decided to use Only(Dim1) which would only Show A for File 1_A.qvw and Show B for File 1_B.qvw.

I hope the above description would make sense.

Best,

Sunny

Re: Action: Open QlikView Document

avinashelite — Fri, 11 Dec 2015 11:53:50 GMT

sunindia‌ thanks a lot for the description . I was thinking about the section access in the document that's why i was wandering why this was needed ...now it make sense ... your trying to achieve the section access through QMC

thanks for the info

Re: Action: Open QlikView Document

sunny_talwar — Fri, 11 Dec 2015 12:00:45 GMT

Yes, you got it