Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
abhaysingh
Specialist II
Specialist II

Expression Help

i have posting date in DD/MM/YYYY format and one field No of days in days format like 20 days, 30 days

i want to add Posting Date + No of Days

what would be expression?

12 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

rangesum([Posting Date], keepchar([No of days],'0123454789'))


talk is cheap, supply exceeds demand
its_anandrjs
Champion III
Champion III

Try like

[Posting Date] + Purgechar( [No of Days], 'daysDAYS')

or

Date#([Posting Date],'DD/MM/YYYY') + Purgechar( [No of Days], 'daysDAYS')

Regards

Anand

abhaysingh
Specialist II
Specialist II
Author

not working pls help,

wat i want is

if( (postingdate + No of credit Days) < TadayDate, sum(collection))

its_anandrjs
Champion III
Champion III

Try like

Date( [Posting Date] + Purgechar( [No of Days], 'daysDAYS') )  //If Date is pure date format

Or

Date( Date(Date#([Posting Date],'DD/MM/YYYY')) + Purgechar( [No of Days], 'daysDAYS') )

Or

if( (Date( [Posting Date] + Purgechar( [No of Days], 'daysDAYS') )) < Today(), sum(collection))

Or

if( (Date( Date(Date#([Posting Date],'DD/MM/YYYY')) + Purgechar( [No of Days], 'daysDAYS') )) < Today(), sum(collection))

Regards

Anand

Anonymous
Not applicable

Hi Abhay,

Please try:

=Date(Date#([Posting Date],'DD/MM/YYYY') + Purgechar( [No of Days], 'NoOfDays'),'DD/MM/YYYY')

Regards

Neetha

abhaysingh
Specialist II
Specialist II
Author

what is daysDAYS?

its_anandrjs
Champion III
Champion III

It is for remove the days string from the field and get only numeric values you can try this way also if there is only days

Date( Date(Date#([Posting Date],'DD/MM/YYYY')) + Purgechar( [No of Days], 'days') )

Regards

Anand

Not applicable

Probably good if you can post up an example app

alkesh_sharma
Creator III
Creator III

Hello Abhay,

Does your field value says 1. 20 Days, 10 Days; or 20, 30 etc.

Case 1

Date(PostingDate + PurgeChar(No.of Days,'DAYSdays'),''DD/MM/YYYY)

Case 2

Date(PostingDate + NO.OF Days ),''DD/MM/YYYY)

This Should work