Projects Expiring 3,6,9 Months - Qlik Community - 991000

Announcements Qlik Connect 2026 Agenda Now Available: Explore Sessions

• Qlik Community
• :
• All Forums
• :
• QlikView App Dev
• :
• Projects expiring 3,6,9 months

Options

• Subscribe to RSS Feed
• Mark Topic as New
• Mark Topic as Read
• Float this Topic for Current User
• Bookmark
• Subscribe
• Mute
• Printer Friendly Page

All communityThis boardKnowledge baseUsersProducts cancel Turn on suggestions Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Showing results for  Search instead for  Did you mean:  Not applicable ‎2015-09-21 06:50 AM

• Mark as New
• Bookmark
• Subscribe
• Mute
• Subscribe to RSS Feed
• Permalink
• Print
• Report Inappropriate Content

Projects expiring 3,6,9 months

I have two fields 'Project_Name' and 'Project_Expiry'. How do I show projects expiring within the next 3, 6, and 9 months ?

Thanks in advance

Ditto - same here! 1,025 Views 0 Likes Reply

• All forum topics
• Previous Topic
• Next Topic

• « Previous Replies
• • 1
  • 2
• Next Replies »

11 Replies Anonymous Not applicable ‎2015-09-21 08:29 AM Author

• Mark as New
• Bookmark
• Subscribe
• Mute
• Subscribe to RSS Feed
• Permalink
• Print
• Report Inappropriate Content

First you need to make sure if you can use days or months.

like for three months you can use 90,120 days and so on

like this :

if(Today()-Project_Expiry>90, if(Today()-Project_Expiry<120,90))

Thanks

BKC

719 Views 0 Likes Reply Not applicable ‎2015-10-06 07:01 AM Author

• Mark as New
• Bookmark
• Subscribe
• Mute
• Subscribe to RSS Feed
• Permalink
• Print
• Report Inappropriate Content

In response to Anonymous

Thanks but Im not sure if this is quite what I'm after. What I need is a new field to show all projects expiring 'within' the next 3, 6 and 9 months not between ....

719 Views 0 Likes Reply Digvijay_Singh MVP ‎2015-10-06 07:12 AM

• Mark as New
• Bookmark
• Subscribe
• Mute
• Subscribe to RSS Feed
• Permalink
• Print
• Report Inappropriate Content

In response to

See if this helps -

Load Project, Date(Date#(ProjectExpiry,'DD-MM-YYYY'),'DD-MM-YYYY') as ProjectExpiry inline [

Project, ProjectExpiry

A, 15-10-2015,

B, 15-11-2015,

C, 15-12-2015,

D, 15-01-2016,

E, 15-02-2016

F, 15-03-2016

G, 15-04-2016

H 15-05-2016 ]

719 Views 0 Likes Reply Not applicable ‎2015-10-06 12:24 PM Author

• Mark as New
• Bookmark
• Subscribe
• Mute
• Subscribe to RSS Feed
• Permalink
• Print
• Report Inappropriate Content

In response to Digvijay_Singh

Thanks this looks good. What if I wanted to show the number of projects rather than the names ?

719 Views 0 Likes Reply Digvijay_Singh MVP ‎2015-10-06 01:01 PM

• Mark as New
• Bookmark
• Subscribe
• Mute
• Subscribe to RSS Feed
• Permalink
• Print
• Report Inappropriate Content

In response to

=Count(if(ProjectExpiry<=Date(AddMonths(Today(),+6)),Project))

719 Views 0 Likes Reply Not applicable ‎2015-10-06 02:22 PM Author

• Mark as New
• Bookmark
• Subscribe
• Mute
• Subscribe to RSS Feed
• Permalink
• Print
• Report Inappropriate Content

In response to Digvijay_Singh

Unfortunately still having trouble with the syntax. Fyi my date is a variable called $(vDate)

719 Views 0 Likes Reply Digvijay_Singh MVP ‎2015-10-06 02:26 PM

• Mark as New
• Bookmark
• Subscribe
• Mute
• Subscribe to RSS Feed
• Permalink
• Print
• Report Inappropriate Content

In response to

You mean you want to replace today() with the variable date? can you share your date format, will provide you the syntax with your date format.

719 Views 0 Likes Reply Not applicable ‎2015-10-06 02:32 PM Author

• Mark as New
• Bookmark
• Subscribe
• Mute
• Subscribe to RSS Feed
• Permalink
• Print
• Report Inappropriate Content

In response to Digvijay_Singh

Sorry ignore that.

I used your statement :

=Count(if(ProjectExpiry<=Date(AddMonths(Today(),+6)),Project))

However I get an 'error in calculation' error in my chart. ps the 'project expiry' date format is m/d/yyyy.

Many thanks

719 Views 0 Likes Reply MK_QSL MVP ‎2015-10-06 02:40 PM

• Mark as New
• Bookmark
• Subscribe
• Mute
• Subscribe to RSS Feed
• Permalink
• Print
• Report Inappropriate Content

In response to

=Count(if(Date#(ProjectExpiry,'m/d/yyyy')<=Date(AddMonths(Today(),+6)),Project))

719 Views 0 Likes Reply Post Reply

• « Previous Replies
• • 1
  • 2
• Next Replies »

Tags

• new_to_qlikview
• new to qlikview
• qlikview_scripting
• qlikview_layout_visuali…
• qlikview_creating_analy…
• qlikview
• script
• chart
• expression
• date
• load
• table
• set_analysis
• expressions
• macro
• analysis
• scripting
• pivot
• set
• dimension

View All ≫ Community Browser

• All Forums
  • GeoAnalytics
  • QlikView Administration
  • QlikView App Dev
  • QlikView Connectivity
  • QlikView Integrations
  • Qlik NPrinting