topic Re: dynamic in script in QlikView

dynamic in script

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

hi all,

currently im writing the where condition in script static. but i want to do dynamic.

can someone help me with the condtion.

where date(Mydate)>='07/01/2020' and date(mydate)<='09/16/2020';

Re: dynamic in script

edwin — Thu, 17 Sep 2020 16:03:01 GMT

pls supply more info. where will the start and end dates come from? how were you thinking of controlling these in your script? will they come from a different table? or a variable?

Re: dynamic in script

Brett_Bleess — Wed, 14 Oct 2020 13:38:03 GMT

Did you try the following:

where date(MyDate)>='07/01/2020'<='09/16/2020';

Not sure if that will work or not, but I think that may be the correct syntax, but I am not certain.

Regards,
Brett