topic Re: problem with subtracting days from date column in QlikView

problem with subtracting days from date column

Anonymous — Tue, 24 Mar 2015 04:37:58 GMT

Hello Experts,

I have date column as time full date and it is having dates like daily. In report i want to display dates as subtract 7 days from time full date as mention below.

I tried with date(interval([Time Full Date] - 7,'D'),'YYYY/MM/DD'), but it is working for only first value and rest of dates are displaying continuosly. Pls help me out on this one.

Regards,

Kumar

Re: problem with subtracting days from date column

danieloberbilli — Tue, 24 Mar 2015 04:45:04 GMT

date(floor([Time Full Date]) - 7,'DD/MM/YYYY')

Re: problem with subtracting days from date column

danieloberbilli — Tue, 24 Mar 2015 04:45:57 GMT

in case that Time Full Date is a timestamp,

else just date(num([Time Full Date]) - 7 , 'DD/MM/YYYY')

Re: problem with subtracting days from date column

Anonymous — Tue, 24 Mar 2015 04:47:33 GMT

Dates can be tricky with qlikview. Whenever I'm in doubt I'll convert the date field in the script to a number. So create a second field Num([Time Full Date]) as [Time Full Date #] and use that in the interval expression you have above.

Re: problem with subtracting days from date column

Anonymous — Tue, 24 Mar 2015 05:20:38 GMT

Hi Daniel,

As you suggested above I tried, but it doesn't work out. Pls see the screenshot.

Re: problem with subtracting days from date column

PrashantSangle — Tue, 24 Mar 2015 05:29:59 GMT

Hi,

This must work.

Try this in Script.

Provide your sample apps?

Regards

Re: problem with subtracting days from date column

danieloberbilli — Tue, 24 Mar 2015 05:30:19 GMT

PFA my example and compare it to yours.

Kind Regards

Daniel

Re: problem with subtracting days from date column

Anonymous — Tue, 24 Mar 2015 06:28:42 GMT

Hi,

Pls find the app.

Regards,

Kumar

Re: problem with subtracting days from date column

PrashantSangle — Tue, 24 Mar 2015 06:37:13 GMT

Hi,

169.6 MB How could you able to upload such huge file???

If possible post reduced file??

Use limited load

Regards

Re: problem with subtracting days from date column

Anonymous — Tue, 24 Mar 2015 06:39:20 GMT

I have converted in script, but it is giving as same as previous. First date value is being deducting and rest of dates are displaying continuously.

Regards,

Kumar

Re: problem with subtracting days from date column

danieloberbilli — Tue, 24 Mar 2015 13:05:19 GMT

Please reduce the file size