topic Re: set analysis date variable in QlikView

set analysis date variable

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

Hi,

I need to add a date variable instead of Date Extract.

sum({$<[Month Abbr]=, Year=, [Quarter Name]=, [Calendar Date]={'>$(=AddMonths(max([Date Extract]),-1))<=$(=max([Date Extract]))'}>}[# QN Open])

Date variable:

v_Caldate = date([Calendar Date],'DD-MM-YYYY')

Thanks...

Re: set analysis date variable

jyothish8807 — Mon, 21 May 2018 06:45:06 GMT

Try like this:

sum({$<[Month Abbr]=, Year=, [Quarter Name]=, [Calendar Date]={'>$(=AddMonths(date(max(v_Caldate),'DD-MM-YYYY'),-1))<=$(=date(max(v_Caldate),'DD-MM-YYYY'))'}>}[# QN Open])

Just check the brackets.

Br,

Re: set analysis date variable

Anil_Babu_Samineni — Mon, 21 May 2018 09:43:15 GMT

I think, this deserve?

sum({$<[Month Abbr]=, Year=, [Quarter Name]=, [Calendar Date]={'>$(=Date(AddMonths(max($(v_Caldate)),-1),'Your Format'))<=$(=Date(max($(v_Caldate)),'Your Format'))'}>}[# QN Open])

Re: set analysis date variable

shiveshsingh — Mon, 21 May 2018 09:49:29 GMT

You need to replace your Date Extract with

$(v_Caldate)