Anyone know where my select statements might be? - Qlik Community

Report Inappropriate Content · ‎2014-06-04

Hello!

New to Qlikview and given the task of working out how to edit a Qlikview sheet created by a former colleague...

I actually need to bring back new tables from the source data (for starters!), but when I go to Edit Script... Main I can't see any select statements, just a number of SET statements and a line showing the directory where Qlikview files are stored.

Can anyone tell me where I should be hunting for Select statements?

Thanks in advance!

John

Anonymous · ‎2014-06-04

Is there a hiddent script there?
Or, is there an "include" statement?

Edit: Are there other script tabs besides Main?

PradeepReddy · ‎2014-06-04

Hi John,

All the script statements might be written in .QVS file and the same file included in the application, Like this..

$(Include=File_Name.QVS).

If so, open the .QVS file from the path specified,do the necessary changes to the script.

Regards,

Pradeep

Report Inappropriate Content · ‎2014-06-11

Thanks for the replies so far - and sorry for the delay in replying. Too much on at the moment!

There is a tab next to Main called Switches. It includes a number of Load * inline [blah blah blah] statements. The stuff in brackets I understand from a word point of view, but it doesn't have the same name as any fields in the underlying Oracle database, or what I can see in File.. Table Viewer. I'm sure the statements in Switches must be referring to something elsewhere.

There is another tab called Optimised Load. First line is LOAD * FROM (points to a directory with loads of *.qvd files, each one seemingly relating to a field in the underlying databse). I'm guessing the first step is altering the *qvd files in this directory to exclude the tables I don't want and bring in what I do want. How would I go about doing this?

Anonymous · ‎2014-06-11

Apparently this is 2-layer (or more) architecture. There is application (qvw file) you describe, and it loads data from the qvd files. And, there is anothe qvw file that reads data from the database - here is where the select statements are - and stores the results in qvd files.