Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Creating a monthly total from daily data

I have data which is broken down by the day but I'd like to show a bar chart which sums up and gives a total for Jan, Feb etc rather than the individual figures for every day of Jan, Feb etc. This is the first time I've used QlikSense I'm sure it's very easy but need some help to get started! Thanks in advance.

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Creating a monthly total from daily data

If you have a month dimension, then just use that as your dimension and use Sum(Sales) as your expression. If you don't have month as a field, then use Month(Date) as your calculated dimension and again use Sum(Sales) as your expression.

HTH

Best,

Sunny

3 Replies
MVP
MVP

Re: Creating a monthly total from daily data

If you have a month dimension, then just use that as your dimension and use Sum(Sales) as your expression. If you don't have month as a field, then use Month(Date) as your calculated dimension and again use Sum(Sales) as your expression.

HTH

Best,

Sunny

Not applicable

Re: Creating a monthly total from daily data

Thank you Sunny for your help, that worked great!

MVP
MVP

Re: Creating a monthly total from daily data

Awesome