Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

evolution for the last 24 months

Hello Guys

I need a graph that contains the evolution of my KPI for the past 24 months

here's my graph :


my expression : month(DATE_CALCUL) and date calcul has this format : DD/MM/YYYY

4 Replies
Champion II
Champion II

read this post

Dates in Set Analysis


Last  24 months for what? While selection you need <24 Months? Can you describe more

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

Dear Weim
I have an idea

your chart can calculate all months value but shows last  24 months (actually it has not good performance but solve your problem)
for this can  set "when number of item exceeds" =24 in presentation tab  and this macro to save scroll of chart at right the macro as below:

set chart = ActiveDocument.GetSheetObject("CH01")

set chartProperties = chart.GetProperties

chartProperties.ChartProperties.XScrollInitRight = true

chart.SetProperties chartProperties

I prepare sample for u but I show the last 4 months value

hope it is helpful for u

Creator III
Creator III

Thank you Samane, will try and let you know