LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Sreya

Hi,

I have already Integrated QlikView with Lavastorm. I am able to load data into QlikView from Lavastorm using the following command in data viewer.

c:\Program Files\QlikView\Qv.exe /l {{^data^}}

However, I have created a graph in QlikView with Lavastorm data. I want to see that graph directly whenever I click on the specific pin instead of loading it and creating it again.

I am using the following command in the data viewer:

c:\Program Files\QlikView\Qv.exe /l /vgraph={{^test.qvw^}} /vinputQvx={{^C:\Users\25293\AppData\Local\Temp\29-Spliting_Prospect_and_NonProspect_Customers.false. qvx]
(qvx);^}} /vpin={{^Spliting_Prospect_and_NonProspect_Customer s.false^}} C:\Users\25293\Desktop\{{^test^}}.qvw

Graph Name I already created in QlikView with the pin output: test.qvw
The input QVX file that has been loaded: C:\Users\25293\AppData\Local\Temp\29-Spliting_Prospect_and_NonProspect_Customers.false. qvx
the pin name: Spliting_Prospect_and_NonProspect_Customers.false

I am only able to see the the start page of QlikView not the graph.

Please help me on what should be done to see the graph directly.


Thanks and Regards,
Sreya Mukherjee

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Sreya

Hi

I am in urgent need for this. We are getting ready for a customer demon on Lavastorm and they want this feature to be explored as well.
Please reply me ASAP.

Thanks in advance.

Best Regards,
Sreya Mukherjee

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Tim Meagher

Hi,

I think that the problem you are having is that you are specifying arguments of the form {{^param^}}, where the "<param>" part is not defined as a parameter.
The parameters that can be used within the configuration are: graph, pin, and data.
This means you can use {{^graph^}} and the name of the graph you have open will be substituted into the command line argument.
Similarly, {{^pin^}} will substitute in the name of the pin that you are viewing, and {{^data^}} will substitute in the full path and file name of the converted data file.

Therefore, instead of using:
c:\Program Files\QlikView\Qv.exe /l /vgraph={{^test.qvw^}} /vinputQvx={{^C:\Users\25293\AppData\Local\Temp\29-Spliting_Prospect_and_NonProspect_Customers.false. qvx]
(qvx);^}} /vpin={{^Spliting_Prospect_and_NonProspect_Customer s.false^}} C:\Users\25293\Desktop\{{^test^}}.qvw

You should simply be able to use:
c:\Program Files\QlikView\Qv.exe /l /vgraph={{^graph^}} /vinputQvx={{^data^}} /vpin={{^pin^}} c:\Users\25293\Desktop\{{^graph^}}.qvw

Hope this helps,

Tim.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Sreya

Hi Tim,

Thanks for you reply.

unfortunately this does not work. I am getting an error like: "Failed to Open the file"

Can you tell me what more should be done on this? Where we are specifying the exact graph name that we are opening?


Thanks and Regards,
Sreya Mukherjee

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Sreya

Hi tim,

we are researching on this QlikView Integration aspect of the tool and we have to go back to the customer after successful implementation of this.

Please help us by providing the solution for the problem stated in the above thread (I am getting an error like: "Failed to Open the file").

Currently the path I am using is:

c:\Program Files\QlikView\Qv.exe /l /vgraph={{^graph^}} /vinputQvx={{^data^}} /vpin={{^pin^}} c:\lavastorm\dataviewer\{{^graph^}}.qvw

Thanks in advance.


Regards,
Sreya Mukherjee

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Tim Meagher

Hey,

What is your graph saved as and what is your qvw file saved as?
From the command line dataviewer script you are using I believe that if the graph name is "MyGraph.brg", then the corresponding QVW created for this graph must exist at:
c:\lavastorm\dataviewer\MyGraph.qvw

The {{^graph^}} parameter will substitute in the name of the current graph - without the .brg extension.

For example, if I create a graph "MyGraph.brg" and then in Tools->Preferences, create a DataViewer called "QlikView Create" with the command line:
c:\Program Files\QlikView\Qv.exe /l {{^data^}}

I can then run a node in the graph, right click and choose Data Viewers->"QlikView Create"

In the generated QlikView document, I can then do what I need to, then save this as C:\Lavastorm\QlikViewers\MyGraph.qvw".

Then within BRE, I can create a data viewer in Tools->Preferences called "QlikView Template":
c:\Program Files\QlikView\Qv.exe /l /vgraph={{^graph^}} /vinputQvx={{^data^}} /vpin={{^pin^}} c:\Lavastorm\QlickViewers\{{^graph^}}.qvw

I can then right click on the node's output and use Data Viewers->"QlikView Template" which will open that qvw with the new data in QlikView.

Regards,
Tim.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Sreya

Originally posted by: Tim Meagher
					

Hey,


What is your graph saved as and what is your qvw file saved as?

From the command line dataviewer script you are using I believe that if the graph name is "MyGraph.brg", then the corresponding QVW created for this graph must exist at:

c:\lavastorm\dataviewer\MyGraph.qvw


The {{^graph^}} parameter will substitute in the name of the current graph - without the .brg extension.


For example, if I create a graph "MyGraph.brg" and then in Tools->Preferences, create a DataViewer called "QlikView Create" with the command line:

c:\Program Files\QlikView\Qv.exe /l {{^data^}}


I can then run a node in the graph, right click and choose Data Viewers->"QlikView Create"


In the generated QlikView document, I can then do what I need to, then save this as C:\Lavastorm\QlikViewers\MyGraph.qvw".


Then within BRE, I can create a data viewer in Tools->Preferences called "QlikView Template":

c:\Program Files\QlikView\Qv.exe /l /vgraph={{^graph^}} /vinputQvx={{^data^}} /vpin={{^pin^}} c:\Lavastorm\QlickViewers\{{^graph^}}.qvw


I can then right click on the node's output and use Data Viewers->"QlikView Template" which will open that qvw with the new data in QlikView.


Regards,

Tim.
			

Hi Tim, Thanks a lot for your quick reply. your solution is working absolutely fine.. I am able to see the graph directly now.
However, I have some more questions on this:

1. can we create more than one Qvw files from different pins from one single graph?
2. How to refresh/reload the data each time while opening the QVW graph from BRE?

Example: I have created a QVW graph with 32 records. Now If the records from BRE changes to 20 then how the QVW will be updated each time? For my case each time the old QVW graph is opening. It is not getting refreshed each time with the new BRE data.

Please help me out on this as early as possible.
Am doing things correctly?
Thanks in advance.

Regards,
Sreya Mukherjee