topic Re: Can we have rename application using variable in QlikView

Can we have rename application using variable

sunil2288 — Thu, 28 May 2015 10:32:36 GMT

Dear Qliktechies,

Here i have a question.

Can we rename an application while saving the Qlikview application using a variable value.

Let's say i have a variable

Let vAppName:- 'ABC'

//Let vAppName:- 'DEF'

//Let vAppName:- 'GHI'

And each time i uncomment one and comment the rest of two and reload the application will save with that variable name.

Here in this case after reloading the application it will be saved as ABC.

Can anyone help me out with this??

Regards

Sunil

Re: Can we have rename application using variable

marcus_sommer — Thu, 28 May 2015 11:15:10 GMT

From inside the app it would be only per macro possible (unless you used manually F12):

ActiveDocument.SaveAs "C:\Mydoc.qvw"

From an external point of view you could use a copy batch like:

copy „C:\MyApp“ „D:\Backup\MyAppXYZ“

- Marcus

Re: Can we have rename application using variable

Peter_Cammaert — Thu, 28 May 2015 11:23:05 GMT

I don't think you can use the ActiveDocument.SaveAs trick to block QlikView/QlikView Server from saving on top of the original document after a reload.

In QlikView Server, the reload will be saved to a temporary file, after which the Distribution Service will copy the temporary file back to the origjnal QVW.AFAIK the Distribution Service doesn't care about executing macro's.

If you plan to interactively do a reload in QV Desktop, then adding a macro that is triggered after the reload will probably fit your requirement.

Peter

Re: Can we have rename application using variable

ToniKautto — Thu, 28 May 2015 11:32:18 GMT

That sounds a bit like lop and reduce in QlikView Publisher, where you get multiple output files based on values in a field.

Re: Can we have rename application using variable

sunil2288 — Thu, 28 May 2015 11:40:06 GMT

Hej Marcus,
Thanks a lot for you quick reply
Is it possible to do something in the same script without doing it externally.

I have declared the variable inside the Load script only. So accessing variable after reloading @Server won't be a problem. But i need to access the Qlikview Application name (May be it is metadata ).

Regards

Sunil

Re: Can we have rename application using variable

sunil2288 — Thu, 28 May 2015 11:44:05 GMT

Hej Peter,

Thanks for your reply!

I need this functionality of dynamically renaming the application which means i just have to comment\uncomment the variable value "vAppName" and the application will be saved with the variable name after reloading the application in Server each time.

It can't be solved using Loop & Reduce as i am not reducing the application based on any value..

Can you please help me with this?

Regards

Sunil

Re: Can we have rename application using variable

sunil2288 — Thu, 28 May 2015 11:44:39 GMT

Hej Toni,

Thanks for your reply!

I need this functionality of dynamically renaming the application which means i just have to comment\uncomment the variable value "vAppName" and the application will be saved with the variable name after reloading the application in Server each time after reload.

It can't be solved using Loop & Reduce as i am not reducing the application based on any value..

Can you please help me with this?

Regards

Sunil

Re: Can we have rename application using variable

marcus_sommer — Thu, 28 May 2015 11:49:48 GMT

It's not possible while the load-execution to save the qvw - also the macro from above won't work because the ActiveDocument didn't exist to that time. But you could create various qvd-output which could be load from these qvw's.

What is the aim from these SaveAs?

- Marcus

Re: Can we have rename application using variable

IAMDV — Thu, 28 May 2015 11:58:52 GMT

Hi Sunil,

How about running a batch script through "Supporting Tasks" or normal task which does the rename after the reload is completed? This way you're not deviating QDS core job of distributing and saving the document. This might be a workaround but I'm not keen on having these things on PROD environment.

Hope this helps!

Cheers,

www.QlikShare.com

Re: Can we have rename application using variable

ToniKautto — Thu, 28 May 2015 12:09:49 GMT

If you have a data island and reduce on a field that has no relation to the rest of the data, I guess you would not practically reduce the actual data.

Re: Can we have rename application using variable

sunil2288 — Thu, 28 May 2015 13:44:54 GMT

Hi Toni,

It is not needed to load any data.

My requirement is i have 3 different Servers from where the data is loading. When i change the name of the server , that time the application should also reflect that it is showing from that Server .

Here in this case Variable 'vAppName' represents the Server name and as it is the Server name when i mention vAppName='ABC' ,it will take that include file which contains ABC Server's connection string.

At the same time it will also change the application name as ABC as it represents ABC Server's data.

I hope i have clarified my requirement.

Regards

Sunil

Re: Can we have rename application using variable

marcus_sommer — Thu, 28 May 2015 14:39:29 GMT

Such a SaveAs directly within the load isn't possible. You could only rename the file after the reload is finished - this could be done with batches or your app-updating will be controlled from another qvw per vbscript.

As alternatively you could use for each server a different app. But is it not enough to display the server origin within the app maybe within a textbox which showed the server-name, load-time and so on.

- Marcus