My previous reporting tool allows me to build a prompted report that runs SQL against a database with variable filters which the user enters manually prior to running the report.
Today, in Qlik, I'm being told I have to preliminarily pull all possible filters options into a QVD so that the user can pick from those options (Dynamic View). This is a massive overhead in my case and frankly, quite redundant. If I'm pulling each and every option for them to choose from, I might as well just add a couple more columns and just pull all the data they need into the QVD. Which would be fine if I was dealing with a smaller dataset. For my use-case, however, I will have to pre-pull something like 2.5 million IDs for this to work.
Today, the user simply knows the ID they're looking for and are perfectly capable of entering it manually without having to pull a list of options.
To that end, I'm looking for the ability to allow users to enter their own filter parameter[s] into a pre-built query and utilize that dataset in a pre-built app. Essentially, ODAG without the dynamic view piece. Also note, for my use-case, I'd need this to work for BigQuery. Thanks!
