topic Re: Last Month Values to Current Month in QlikView

Last Month Values to Current Month

sfloberg — Sat, 16 Nov 2024 00:53:12 GMT

How can I take previous month (current year) of data and add it to the current month (current year)?

//Code for loading previous years of data
......

//Code below is current year january to last month (march as of now). When a new month has passed the data is added into the file.
Concatenate(tmp_currency)
LOAD Date(Date#(Datefield,'YYMMDD'),'YYYY-MM-DD') as Datefield,
Data
FROM ....
(biff, embedded labels, table is Sheet1);

Re: Last Month Values to Current Month

rubenmarin — Wed, 08 Apr 2020 10:47:59 GMT

Hi, add one month to date can work?:

//Add previous month data to next month Concatenate(tmp_currency) LOAD Date(AddMonths(Date#(Datefield,'YYMMDD'),1),'YYYY-MM-DD') as Datefield, Data as DataLastMonth FROM .... (biff, embedded labels, table is Sheet1);

You can add a 'Where' clause to limit to one month and also to not add rows "after AddMonths(Today(), -1)" to not create future data.

You can also do a group by to keep Data and DataLastMonth in one row per Datefield.