Re: Date Limitation. - Qlik Community

Report Inappropriate Content · ‎2016-09-19

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.

jpenuliar · ‎2016-09-19

Can you post a your work?

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

Report Inappropriate Content · ‎2016-09-19

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

jonathandienst · ‎2016-09-19

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Anil_Babu_Samineni · ‎2016-09-19

Do you have forecast data?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

el_aprendiz111 · ‎2016-09-19

Hi,

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

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

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

Report Inappropriate Content · ‎2016-09-19

Thank you.How can I put this in set analysis

neelamsaroha157 · ‎2016-09-19

Try this

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

Variables:

vToday = Today()

vRollingNext14MonthDate = AddMonths(Today(),14)

You can use max instead of today()

sunny_talwar · ‎2016-09-19

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