Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date function.

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.

7 Replies
Creator III
Creator III

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?

Master
Master

hi stacey,

please be more specific of your requirement.

so can help

Regards

Neetha

Not applicable

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

Not applicable

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.

Not applicable

Hello,Sry 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.

Not applicable

Hello,sry

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.

Partner
Partner

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