Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

What QlikView generate in background

Can any one tell me Is there any sql queries generated while reloading the dashboard in QlikView if yes so how can I get that.Please any one give me the answer.

Regards

Surbhi Sahu

Bisp Solutions Inc

http://bisptrainings.com

2 Replies
Not applicable
Author

Go to Settings > Document Properties > check Generate Logfile ... then load Qlikview ... you can see a notepad is create in the path, where you can go thought the script .. You can check that script in the qlikview with Ctrl + E


hic
Former Employee
Former Employee

When QlikView reloads data, it just executes the script. No other queries are generated.

However, if you use Direct Discovery by defining a "DIRECT SELECT" in the script, individual charts in QlikView may generate SQL queries. See more on http://community.qlik.com/blogs/theqlikviewblog/2012/10/19/self-service-big-data-analysis-with-qlikv...

HIC