This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I am trying to aggregate values on a monthly basis.
I have the following data points:
I would like to instead present the data as
I am not able to follow the example presented here:
Aggregate data on monthly basis http://www.qlikcommunity.com/message/292323#292323
If possible could someone provide a more straightforward way of doing this?
Create a chart:
- create a dynamic dimension using =date(MonthStart(Date) , 'MMM YYYY')
- create an expression =sum(Revenue)
View solution in original post
Load * INLINE [
MonthName(Date) as Month_Year,
Drop Table Test;
Month(Date)&Year(Date) as MonthYear,
group by MonthYear
Hope this helps
sum(Revenue) as Revenue,
Forgot to sum it by MonthYear previously.