Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
agni_gold
Valued Contributor II

Qlikview edit script is not showing.

I have a QVW file but when i open edit script , there is no script , in that case i have already checked there is no hidden script . so how can i see the script behind application.

7 Replies
michielvandegoo
Valued Contributor

Re: Qlikview edit script is not showing.

Is there a binary load in the script? If so, the very first row in the script would be: binary .......

Keep in mind that a binary load always is the first statement in a script and therefore is placed before the set statements in the main tab.

nareshguntur
Valued Contributor

Re: Qlikview edit script is not showing.

Has that been developed by some other person. Might be he has reloaded, then removed the entire script, saved the document and shared it with you.

Cheers,

Naresh

MVP
MVP

Re: Qlikview edit script is not showing.

Is the script Window opening and showing as empty or is the Window not appearing at all?

If it is the former, has the application been reloaded and distributed by publisher?  Publisher strips the load script out of documents when they are reloaded and sent to a different location - this is so a restricted user can not reload the script to pull in data beyond that which has been given to them.  You need to be very careful with Publisher that you don't distribute an app over the top of the source application - as it can cause the script to get lost.

If you are not seeing the edit script dialog at all it may be that it is opening up on a second screen.  If you do not have a second screen plugged in then you may not be able to see this.  The easiest way to solve this is to borrow a monitor and drag the window back on to your main screen.

Hope one of those suggestions helps.

Steve

agni_gold
Valued Contributor II

Re: Qlikview edit script is not showing.

If it is the former, has the application been reloaded and distributed by publisher?  Publisher strips the load script out of documents when they are reloaded and sent to a different location - this is so a restricted user can not reload the script to pull in data beyond that which has been given to them.  You need to be very careful with Publisher that you don't distribute an app over the top of the source application - as it can cause the script to get lost.

So Steve , what can i do for this situation ?

MVP
MVP

Re: Qlikview edit script is not showing.

Hi,

If you want to distribute different sub sets of the app to different users

then you need to ensure your Source Document folders (set under

Distribution Services settings) are different to those that you use for

Access Point (set under Server Settings). On reload the document is moved

from the source to the distribution folder.

If you don't want to create different subsets or use QlikView to set up the

Active Directory security for you then it is possible to reload in-situ.

Set both lots of folders to be the same and untick all the distribution

options of your reload task.

Hoe that helps.

Steve

agni_gold
Valued Contributor II

Re: Qlikview edit script is not showing.

If you want to distribute different sub sets of the app to different users

then you need to ensure your Source Document folders (set under

Distribution Services settings) are different to those that you use for

Access Point (set under Server Settings). On reload the document is moved

from the source to the distribution folder.

Steve is this able to retrive the script? , do we need to perform some other steps.

MVP
MVP

Re: Qlikview edit script is not showing.

If you have already overwritten the QVW with the script in with one that does not have the script then you will have lost it, I'm afraid.  You will need to revert to a backup, if you have one.

If you do have a backup you can use the Export Script option to write code from all tabs to a single file - this can then be copied and pasted back into the load script.

If you don't have a backup then you may be able to obtain much of the load script from the .log file associated with the QVD - provided logging was switched on.

Unfortunately Publisher doesn't back up target documents before overwriting them, so if neither of those other options are open to you then it is a case of writing the script again.

- Steve

Community Browser