topic Re: Line Chart grouped by month in QlikView

Line Chart grouped by month

sqlpuzzle — Thu, 20 Jul 2017 20:00:15 GMT

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.

Re: Line Chart grouped by month

zhadrakas — Fri, 21 Jul 2017 06:01:43 GMT

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