Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Tags (1)
2 Replies
Not applicable

Re: What QlikView generate in background

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


Re: What QlikView generate in background

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