Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
sqlpuzzle
Contributor III
Contributor III

Line Chart grouped by month

I need to display a trendline of counts by month. I have a Slider that control the time range ( Each step in the slide is a month). With the help of Antonio our respected community member, I was able to control the count of records that fall in the slider range. Now I would like to get the count of the same records grouped by month and shown in a line chart.  I am looking for the expression to get that done.

A sample is attached.

Thanks to the Qlik Community to help me learn.

1 Reply
zhadrakas
Specialist II
Specialist II

To get this work, you have to link your Master Calender to your fact table.

You can just add this line to your mastercalender load Statement.

,tempdate as begindate

then you could just add this Dimension

Count(Country)

regards

tim