3 Replies Latest reply: Sep 14, 2017 11:55 AM by Nate Hallquist RSS

    Input Box in Data Load Editor

    Jay Padhya

      Hi Guys,

       

      I have seen a thread previously where a user has asked this question but this is quite different. I would like to have an input box that will take dates and sample size from the user and then query the database which is on server (not local). The table is huge and it takes forever to load in Qlik's memory.

       

       

      Is there any way to have like either a pop up box asking for start and end dates, and sample size and then querying on basis of the dates.

       

      Here is my query:

       

      XYZ:

      SQL select * from TBXYZ;

      LOAD *;

       

      MEASURE:

      SQL select * from TBMEASURE:

      where START_DATE = "2017-01-01" and END_DATE = "2017-08-08"

      LOAD *;

       

      Thanks