Discussion board where members can get started with Qlik Sense.
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.
load ...your data
where 'date' < 'prior 6months'
group by 'key'
load ...same data
where 'date' > 'prior 6months'
and data will be concatenated
here is one working example based on the data below:
LOAD Date(Date) as Date, Value Inline [
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)