topic Difference between two dates in QlikView

Difference between two dates

Tue, 08 Feb 2011 08:46:49 GMT

Hi,

I have one requirement where date difference should be 1 year. like below example

Today is 8th Feb 2011. I want to create one button which should select 1 year difference like 1st Feb 2010 to 31st Jan 2011 so the difference is 1 year.

If I refresh the dashboard in coming month from 1st march 2011 to 31st March 2011 then the Data selection should be 1st March 2010 to 29th Feb 2011.

Could you pls let me know how to implement this requirement.

Thanks,

AW:Difference between two dates

brenner_martina — Tue, 08 Feb 2011 09:03:31 GMT

Hi,

you can use a lot of datefunctions:

Year(Datefield) and (Year(Datefield)-1)

Makedate(Year(Datefield),Month(Datefiled),Day(Datefield)) and

Makedate((Year(Datefield)-1),Month(Datefiled),Day(Datefield))

Difference between two dates

disqr_rm — Tue, 08 Feb 2011 09:20:51 GMT

Create a button and put Action to select your Date field with following value expression:

='>' & addmonths(today(), -12) & ' <' & today()

This should select last 1 year dates, provided your Date field is actually a valid Date type content.

Hope this helps you.

Difference between two dates

Tue, 08 Feb 2011 10:39:50 GMT

Thanks Rakesh, but I am not sue how to proceed. I just created one button and under action tab I clicked on Add buttton here I have question what should I select and where I have to paste this formula?

But if I click on that button it should select 1 year difference data

Thanks,

Difference between two dates

disqr_rm — Tue, 08 Feb 2011 11:14:41 GMT

Under Actions tab press "Add" button

Action type: Selection, Action: Select in Field, Press OK

In the field "Field" on the right, type the field name in your data model you want to select these days.

In the "Search String" field enter the expression I gave you: ='>' & addmonths(today(), -12) & ' <' & today()

Press OK and try the button.