topic Re: difference in days in straight table in QlikView

difference in days in straight table

Wed, 08 Oct 2014 10:59:42 GMT

Hi All,

I got a requirement as follows:

i have a data in straight table with 3 columns old brand,new brand and their brand dates.

Now i want one more column as difference in days when compared to below row date in a date column.

For example:

In the above table, i want to show difference(Days) column in qlikview.

PrashantSangle — Wed, 08 Oct 2014 11:03:13 GMT

Hi,

Use Interval(DateField-below(DateField),'D')

Regards

Wed, 08 Oct 2014 11:11:49 GMT

HI Max,

I tried with your solution but it is showing '-' in the table column.

senpradip007 — Wed, 08 Oct 2014 11:17:43 GMT

PFA. Hope it will help.

PrashantSangle — Wed, 08 Oct 2014 11:35:45 GMT

Hi,

Try this

Interval(Date(DateField-Above(DateField)),'D')

Check DateField Format

Regards

Wed, 08 Oct 2014 12:52:27 GMT

HI,

can anyone help me on this i am missing out something.

JonnyPoole — Wed, 08 Oct 2014 15:15:24 GMT

The basic expression is as follow:

below( total Date,1,1) - Date

The 'TOTAL' is key so that it looks over all dimensions and not restricted to the current rows dimensional value

To ensure your values are read as a date you below( total Date,1,1) - Date can try the following as well based on the format you posted above:

below ( total date(date#(Date, 'DD/MM/YYYY')) , 1, 1) - date(date#(Date, 'DD/MM/YYYY'))