topic Re: Date function. in QlikView

Date function.

Tue, 04 Aug 2015 18:21:58 GMT

How can I display date in 1,3,6,9,12,15,18,21,24,27 format.Only I want to display until 27 months.

Thanks in advance.

Re: Date function.

datagrrl — Tue, 04 Aug 2015 18:30:28 GMT

I think we need more information, are you asking for the difference in months?

This might be a good thread for you:

How Do I Get the Number of Months Between Two Dates?

Re: Date function.

Anonymous — Tue, 04 Aug 2015 18:30:43 GMT

hi stacey,

please be more specific of your requirement.

so can help

Regards

Neetha

Re: Date function.

Tue, 04 Aug 2015 18:48:04 GMT

are you asking about building a list of dates that show the 1st, 3rd, 6th, 9th, 18th, 21st, 24th and, 27th of each month?

please clarify/confirm

Re: Date function.

Wed, 05 Aug 2015 00:47:03 GMT

Hello,Sorry abt that.

I have a date field called 'validityDate' which displays Date values . Date format is 30-Nov-2014.'

So now I want to group this dates into 1,3,6,9,12,15,18 format.If its 30 days from today then 1 month,if its 90 days from today then 3 months so on until if its 540 days from today then 18months .So in a list box i want to display

1 month

3 months

6 months

9 months

12 months

15 months

18 months as filter.

Re: Date function.

Wed, 05 Aug 2015 00:47:19 GMT

Hello,Sry abt that.

I have a date field called 'validityDate' which displays Date values . Date format is 30-Nov-2014.'

1 month

3 months

6 months

9 months

12 months

15 months

18 months as filter.

Re: Date function.

Wed, 05 Aug 2015 00:47:30 GMT

Hello,sry

I have a date field called 'validityDate' which displays Date values . Date format is 30-Nov-2014.'

1 month

3 months

6 months

9 months

12 months

15 months

18 months as filter.

Re: Date function.

maximiliano_vel — Wed, 05 Aug 2015 01:16:56 GMT

Please see attached file, this was take from Rob Wunderlich

rwunderlich‌

Search Recipes | Qlikview Cookbook

In the link Check Date-Grouping

I just made some few adjustments for you

Regards