Parameter To Filter

[ramkrishna86]

Hi,

I need to pass a parameter to filter loaded data in WHERE clause in my data load script.
Is it possible at all? If yes, then how this can be done?

Thanks

[tomasz_tru]

Yes it is. For example for SQL and date:

SET vDate = '2017-08-01';

SQL SELECT * FROM table WHERE date = '$(vDate)';

[ramkrishna86]

I mean how to pass parameter from UI?

[tomasz_tru]

On demand app generation: Managing big data with on-demand apps ‒ Qlik Sense