topic Date Limitation. in QlikView

Date Limitation.

Wed, 25 Nov 2020 16:16:04 GMT

I have to limit LXD to catch within nect 14 months from today and I tried below script in list box to test...but its not working..

=IF([LXD] > today() and [LXD] < addmonths(today(),14),[LXD])

Thanks mmuch.

Re: Date Limitation.

jpenuliar — Mon, 19 Sep 2016 13:12:54 GMT

Can you post a your work?

is there any data that shuld match today until 14 months forward?

Re: Date Limitation.

Mon, 19 Sep 2016 13:16:14 GMT

I have to limit the date selection for the next rolling 14 months.

Re: Date Limitation.

jonathandienst — Mon, 19 Sep 2016 13:26:16 GMT

Try

=Aggr(If(LXD > Today() And LXD < Addmonths(Today(), 14), LXD), LXD)

Is LXD a numeric WV date, or is it a string. If the latter, convert this to a date at initial load using the Date#() interpretation function. AddMonths() does not work on a string.

Re: Date Limitation.

Anil_Babu_Samineni — Mon, 19 Sep 2016 13:38:36 GMT

Do you have forecast data?

Re: Date Limitation.

el_aprendiz111 — Mon, 19 Sep 2016 13:44:56 GMT

Hi,

=if(Date#(LXD ,'DD/MM/YYYY')>Today(),

Date#(AddMonths(Today(),14),'DD/MM/YYYY'),

Date#(LXD ,'DD/MM/YYYY'))

Re: Date Limitation.

Mon, 19 Sep 2016 17:16:03 GMT

Thank you.How can I put this in set analysis

Re: Date Limitation.

neelamsaroha157 — Mon, 19 Sep 2016 17:36:24 GMT

Try this

Only({<LXD={">=$(vTodayDate)<=$(vRollingNext14MonthDate)"}>}[LXD])

Variables:

vToday = Today()

vRollingNext14MonthDate = AddMonths(Today(),14)

You can use max instead of today()

Re: Date Limitation.

sunny_talwar — Tue, 20 Sep 2016 01:54:38 GMT

Where are you trying to limit this? Chart? Script? Is LXD read as date? If it is read as date, what is its format?