In a dashboard I made on Power BI I inserted a created parameter directly into my SQL query statement to prevent the table from loading in ALL data but rather directly manipulate it for the users desired request. The syntax looks something like this:
Spend_Date BETWEEN '"&parMinInvoiceDate&"' AND '"&parMaxInvoiceDate&"'.
I was then able to link the parameter I created to a filter pane so that they could select a min and max date range and it would write that into the SQL itself. I am looking to replicate this in Qlik but don't know how. Any suggestions?
