Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
parul_mehta
Partner - Creator
Partner - Creator

Dynamic refresh of qlikview from database

Hi,

I have an application wherein there is 30 crores plus data.

The requirement is that the data not be stored in Qlikview

Instead an input box should be available to user, and on entering the component value, data for that component value should be dynamically fetched from the database.

Please provide inputs on how this can be done.

Also the user will be accessing the dashboard from access point, what can be a way for dynamic user input ?

3 Replies
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Parul,

It should be stored in Qlikview then only it will give the result.

You might provide input box to filter data.

Thanks,

Arvind Patil

marcus_malinow
Partner - Specialist III
Partner - Specialist III

Hi Parul,

given a well structured data model you should be able to deal with this volume of data. However you might want to look into Direct Discovery.

QlikView Direct Discovery FAQ 11.2 SR7.pdf

Direct Discovery in Qlikview

Marcus

Not applicable

If users use desktop client, its possible and reload depends on your database performance. This options doesn't work on AJAX client directly,

As Marcus said, well structured data model and some UI techniques you should able to deal GB of data easily in Qlikview.

At last, check out Direct Discovery option as well.