topic Re: Previous Date From Given Date in QlikView

Previous Date From Given Date

vijayit43 — Thu, 11 Sep 2014 06:28:26 GMT

if i have select from date '15 aug 2014' and to date'25 Aug 2014' then days diff 10 i want to previous 10 days date from 15 Augest(5 Aug 2014) how to do that Please help.

Re: Previous Date From Given Date

ajaykumar1 — Thu, 11 Sep 2014 06:38:07 GMT

Hi,

Try like ;

Load * inline

[period

08/11/2014

];

text object :date((date(period)-10)) and output is 8/1/2014

Regards,

Ajay

Re: Previous Date From Given Date

PrashantSangle — Thu, 11 Sep 2014 06:43:58 GMT

Hi,

Create One Variable

varDaysDiff

Expression=

Interval(to_date-star_date,'D')

Then use that variable whereever you want that difference

Like if you want to show in text objec

Then write expression like

=Date(start_date-varDaysDiff)

Regards

Re: Previous Date From Given Date

muniyandi — Thu, 11 Sep 2014 06:45:14 GMT

Hi Vijay,

Try this expression:

Variable1 = First Date (15/Aug/2014)

Variable2 = Last Date (25/Aug/2014)

Variable3 = Date(Varaiable1-(Varaiable2 -Varaiable1 ) )

Thanks,

Muni

Re: Previous Date From Given Date

Thu, 11 Sep 2014 06:46:33 GMT

Add a extra field in the script which will store Numeric value corresponding to date.

And then use that field to go to and fro in dates..

Thanks,

Singh