topic Expression Help in QlikView

Expression Help

abhaysingh — Wed, 03 Dec 2014 10:04:07 GMT

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?

Re: Expression Help

Gysbert_Wassenaar — Wed, 03 Dec 2014 10:06:54 GMT

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

Re: Expression Help

its_anandrjs — Wed, 03 Dec 2014 10:10:12 GMT

Try like

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

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

Regards

Anand

Re: Expression Help

abhaysingh — Wed, 03 Dec 2014 10:15:00 GMT

not working pls help,

wat i want is

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

Re: Expression Help

its_anandrjs — Wed, 03 Dec 2014 10:23:28 GMT

Try like

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

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

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

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

Regards

Anand

Re: Expression Help

Anonymous — Wed, 03 Dec 2014 10:34:25 GMT

Hi Abhay,

Please try:

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

Regards

Neetha

Re: Expression Help

abhaysingh — Wed, 03 Dec 2014 11:47:36 GMT

what is daysDAYS?

Re: Expression Help

its_anandrjs — Wed, 03 Dec 2014 11:51:23 GMT

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

Re: Expression Help

Wed, 03 Dec 2014 12:00:36 GMT

Probably good if you can post up an example app

Re: Expression Help

alkesh_sharma — Wed, 03 Dec 2014 12:01:39 GMT

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

Re: Expression Help

abhaysingh — Wed, 03 Dec 2014 12:10:21 GMT

what is DAYSdays...

Re: Expression Help

its_anandrjs — Wed, 03 Dec 2014 12:15:10 GMT

Hi Abhay,

In the fields you have data 20 days, 30 day so for getting 20,30... we have to remove day string from field for this i use Purgechar to remove day, days or DAYS if this string in the field then this string removes from the field and you get 20,30....

You can try

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

Regards,

Anand

Re: Expression Help

alkesh_sharma — Wed, 03 Dec 2014 12:16:52 GMT

Purgechar function removes the characters from the field value.

For eg: purgechar(abc123,'123') output is abc, therefore the characters 123 has been purged/removed