Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
kalshammeri
New Contributor II

Struggling to find databases views used in qlikview dashboard

Hi all,

Our qlikview reports using some other systems (business and billing) data to display in dashboards such as views, tables etc.

Still couldnot understand and find those tables, views in  BI reports. you help is highly appreciated.

 

Thanks

3 Replies
MVP & Luminary
MVP & Luminary

Re: Struggling to find databases views used in qlikview dashboard

You'll have to look at the load script of the Qlikview document to find out where the source data came from. Once the data is loaded into the Qlikview document the charts use the internal data model directly. The charts won't connect to database views. 


talk is cheap, supply exceeds demand
kalshammeri
New Contributor II

Re: Struggling to find databases views used in qlikview dashboard

Good explanation, but I found the source document that would reflect on the charts, the question now, where are the views that used to get data from other database. Thanks
MVP & Luminary
MVP & Luminary

Re: Struggling to find databases views used in qlikview dashboard

As I said the load script is where you can find the statements that load the data from the sources. If there are database views used then you should be able to find the SQL Select statements that use them. Possibly you're looking at the final dashboard document that does not load data from database sources but from another qlikview document or from qvd files. In that case you'll have to look at the load script of that other document or the document that created the qvd files.


talk is cheap, supply exceeds demand