topic Reload by person required in textbox in QlikView

Reload by person required in textbox

kkkumar82 — Mon, 10 Aug 2015 11:30:06 GMT

Hi Qlikers,

I have a qvd extractor template which I use to create qvd file(every 4 to 5 days) manually, the template is used by me and my colleague and for the latest reload time I have used reload() in a text box with osuser() such that the last reload() person along with the time will be known.

Here comes the challenge when this file is opened in my friends system it is showing his last reload vice versa, is there a way to show all the reloads of both of us with osuser() returns value in the text box irrespective of the user who opened it.

1. kk reloaded at 6/08/201512.55PM

2. Rk reloaded at 6/08/2015 1.50 PM

etc

Thanks

Kiran Kumar

Re: Reload by person required in textbox

sunny_talwar — Mon, 10 Aug 2015 11:36:36 GMT

May be you can use a text file with your name on your computer and your friends name on your friend's computer which gets pulled into a variable and get's saved every time your reload the application just like your save the reload time.

HTH

Best,

Sunny

Re: Reload by person required in textbox

maxgro — Mon, 10 Aug 2015 11:43:12 GMT

do you reload the same .qvw or a different one (2 copy)?

for the same I think you can add at the end of the script (history of reload time and osuser)

load * from r.qvd (qvd);

load ReloadTime(), OSUser() AutoGenerate 1;

store r into r.qvd (qvd);

if you have different .qvw maybe the same idea but you have to read/store the qvd from a common folder

hope to understand