On Demand Queries

[Anonymous]

Hello,

What does Qlik Sense have for on demand querying other than On Demand App Generation?

I have fairly large data, 1 billion + rows, and it is becoming unmanageable to load all of it in memory.

Assume I require access to all of the data.

Any thoughts on how others have handled this problem (native, API or data architecture changes are all on the table) are appreciated.

Thanks!

[rdrivas]

Don't use ODAG, it is not possible to deploy between environments without manual intervention, time consuming + open to introduce new issues.

If you promote from UAT to LIVE ODAG reports, you will have to manually setup report template every time, forget about DevOps approach. 2 years old issue.     https://support.qlik.com/articles/000056504

If you don't have full access to LIVE environments you need to introduce other tool, I recommend Power BI to on-Demand reports with huge datasets and it is really cheap.

Regards

Rodrigo