Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
munibridgei2i
Contributor
Contributor

How to aggregate the data by month

Hi All,

I have 5 years of daily data and i would like to aggregate the data by month but i don't want aggregate current quarter and 2 prior quarter data that should be non aggregated.

Please help me how to solve this issue, Thanks in advance.

Regards,

Krishna.

2 Replies
kfoudhaily
Partner - Creator III
Partner - Creator III

load ...your data

where 'date' < 'prior 6months'

group by 'key'

load ...same data

where 'date' > 'prior 6months'


and data will be concatenated

QlikView Qlik Sense consultant
YoussefBelloum
Champion
Champion

Hi,

here is one working example based on the data below:

aggregate:

LOAD Date(Date) as Date, Value Inline [

Date, Value

18/01/2018, 100

21/02/2018, 98

11/03/2018, 48

07/04/2018, 54

12/01/2017, 153

21/01/2017, 92

09/02/2017, 94

11/02/2017, 109

15/03/2017, 52

17/03/2017, 67

];

on the app attached below, you will find how to aggregate your data by the Month of the Date field (Creating MonthYear field for better readability)


PFA