topic add variable to SQL in load in QlikView https://community.qlik.com/t5/QlikView/add-variable-to-SQL-in-load/m-p/637598#M1089693 <HTML><HEAD></HEAD><BODY><P>I have a SQL statement that i run manually from my system with a parameter of MONTH. It prompts me and I add whichever month I happen to be querying. I would like to implement this in Qlikview with a variable for MONTH and a counter so that I can say, IF COUNT &lt; 5, COUNT ++ and IF COUNT = 1, MONTH = 'JAN'. Is there any way to use such logic in a load statement?</P></BODY></HTML> Tue, 03 Jun 2014 15:10:42 GMT 2014-06-03T15:10:42Z add variable to SQL in load https://community.qlik.com/t5/QlikView/add-variable-to-SQL-in-load/m-p/637598#M1089693 <HTML><HEAD></HEAD><BODY><P>I have a SQL statement that i run manually from my system with a parameter of MONTH. It prompts me and I add whichever month I happen to be querying. I would like to implement this in Qlikview with a variable for MONTH and a counter so that I can say, IF COUNT &lt; 5, COUNT ++ and IF COUNT = 1, MONTH = 'JAN'. Is there any way to use such logic in a load statement?</P></BODY></HTML> Tue, 03 Jun 2014 15:10:42 GMT https://community.qlik.com/t5/QlikView/add-variable-to-SQL-in-load/m-p/637598#M1089693 2014-06-03T15:10:42Z