Hi,
I have huge data 100 million rows and 40 columns what I need to understand is :
Whether I can create an app which will take user input and then reload and give the output in QlikSense
On demand Query on SQL and provide data
Example below we have data for Table1
| ID | date | Header 3 | Header 4 | Header 5 | Header 6 | Header 7 | Header 8 |
|---|
| 1 | 01-02-2018 | xxx | | | | | |
| 2 | 02-02-2018 | xxx | | | | | |
| 3 | 19-04-2018 | xxx | | | | | |
| 4 | 18-05-2018 | xxx | | | | | |
| 5 | 20-09-2018 | xxx | | | | | |
Select * from Table1 where ID= (user Input)
Suppose user provides input as "1" in app data should reload and fetch the output as below table:
|
| date | Header 3 | Header 4 | Header 5 | Header 6 | Header 7 | Header 8 |
|---|
| 1 | 01-02-2018 | xxx | | | | |
In this case ID is provided by user
ID will be provided by user
