Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

comparisons between SQL queries and QlikView queries

Hi Guys,

please provide comparisons between SQL queries and QlikView queries.

regards,

Anvesh

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: comparisons between SQL queries and QlikView queries

Qlikview does not have queries. If you select a value in a listbox or in a chart then the entire in-memory database will be filtered using that selection. You continuously interact directly with the entire in-memory database. Ok, that's a bit of a simplification because I'm ignoring alternate states and set analysis for now. But thus simplified, if you interact with a Qlikview document all the charts are using the same 'query' that returns all the data from a single big table.


talk is cheap, supply exceeds demand
Highlighted
Contributor III
Contributor III

Re: comparisons between SQL queries and QlikView queries

Hi Gysbert,

Thanks for your reply.

But my question is regarding development side, its not about designing side.

Regards,

Anvesh

Highlighted
MVP & Luminary
MVP & Luminary

Re: comparisons between SQL queries and QlikView queries

Then you'll have to explain your question. What do you want to know? What's your definition of a qlikview query?


talk is cheap, supply exceeds demand