Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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