topic Re: Remove Hardcoding and use variable in QlikView

Remove Hardcoding and use variable

bharatkishore — Thu, 04 Oct 2018 10:49:55 GMT

Hi All,

I have the below code:

load Market,

Date as [Month-Year]

Resident FinalTable Where Date <>'2018-09'

Instead of giving a hard coded value 2018-09 can i give in a variable.

Can you please tell me how can i do.

Thanks,

Bharat

Re: Remove Hardcoding and use variable

olivierrobin — Thu, 04 Oct 2018 11:34:32 GMT

hello

you can use the $() notation

let vDate='2018-09';

and in your load

where Date<>'$(vDate)'

Re: Remove Hardcoding and use variable

bharatkishore — Thu, 04 Oct 2018 11:53:25 GMT

HI Oliver,

Thanks for your reply. But next month it will be '2018-10'.. Can we write in such a way that it happens automatically for every month. Please let me know.

Re: Remove Hardcoding and use variable

olivierrobin — Thu, 04 Oct 2018 11:57:42 GMT

let vDate=date(now(),'YYYY-MM')

Re: Remove Hardcoding and use variable

bharatkishore — Thu, 04 Oct 2018 12:10:28 GMT

Thanks for your reply.

But if i give this i am getting 2018-10, But in my data i have date till 2018-09 and i need to exclude that one. Sorry if i am not clear..

Please let me know if you know anything more..

Re: Remove Hardcoding and use variable

bharatkishore — Thu, 04 Oct 2018 12:24:06 GMT

I have given like this.. guess it should work ..date(AddMonths(Today(),-1),'YYYY-MM')

Re: Remove Hardcoding and use variable

shwethaa — Thu, 04 Oct 2018 18:34:15 GMT

Try this-

Date(monthstart(today())-1,'yyyy-mm')