
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Subtracting 1 month from date susequently
Hello Experts,
I want to subtract from 1 month subsequently from current date. For example today is 25/03/2015, I want to see data as 25/02/2015
25/01/2015
25/12/2014
.
.
..
like this
Can anybody suggest how to do this.
Regards,
Kumar Reddy@
- Tags:
- new_to_qlikview


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
Try this:
Addmonths(Today(),-rowno())
HTH
Sushil

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I am new to qlikview, Can u pls explain in detail.
Regards,
Kumar


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Addmonth function will add month in your date.
so here we have date as today() date and rowno will generate a sequence in your table from 1 to n..
so at each level 1 month will be subtracted from today's date.
HTH
Sushil

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Actually this is my requirement
Date values are coming from date column and those metrics have been calculated based on counts. I have calculated expression, but the problem is with dates.
Regards,
Kumar

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Try this
Dats:
load
AddMonths(date,-1) AS New_date,
* Inline [
date,sales
12/02/2015,100
15/02/2015,50
20/03/2015,80
30/03/2015,600
];
The New_date would be your Page column
Hope this helps
