deleted variable keeps coming up

[Anonymous]

Hi experts,

I am deleting a variable, save the qvw, and run it from the publisher. As soon as the task runs completely the variable is again created in the qvw. What could be the source? Varibale is not being updated by any spreadsheet. I am wondering where I should look for the source that keeps creating deleted variable.

Thanks!

[Anonymous]

nothing special. Very simple Trigger . There is an odbc connection so I can't run the task from Desktop and check. For any reload I have to resort to publisher.

[Anonymous]

I highly appreciate everyone's effort. I will try to look into it fresh tomorrow.

[swuehl]

Yes might be a good idea, to look into this fresh tomorrow, also for us..

Could you then please also state the variable name and usage?

Regards

Stefan

[maximiliano_vel]

Please check if you have an input box object on your qvw file, if so, check if you are displaying the variable on that object, delete the object or the variable...

Hope this help.

Regards.

[Anonymous]

Hey Stefan,

I again tried to solve the puzzle today. In order to get to the bottom of this issue I started taking off fat. I removed all the current sheets so removed all the current objects and removed macro. When I reloaded script again the variable appeared.

QvWorkPath: \\XPQVDEV\QVSERVER\NEW_QV_FOLDER_STRUCTURE\APPLICATIONS\PUBLISHED_DOCS

                            (variable is defining path)

One thing that I have noticed- when I directly log on the server (Computer- \\XPQVDEV ) and open application, the variable is invisible. But when I open application from Network drive mapped on my personal system, the variable shows up. In both the cases I am opening the same QVW. Probably you might conclude something.

Thanks!

[Anonymous]

When I was checking I removed all the existing objects.

[swuehl · Accepted solution]

QlikRajan,

we are hunting for a system created variable then:

QvWorkPath

Returns the browse string to the current QlikView document. A system-defined variable.

I believe you can't delete this variable.

[Anonymous]

Could I have a look at all the system created variable somewhere. The system generated variables I know are like these-

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

SET hideprefix = '%';

Could you please shed some more light. I think you have got to the point.

[swuehl]

Add the variables listed in the HELP, chapter System Variables.

[awhitfield]

That's created the first time you save and reload a qvw by default.

Andy