topic Re: evolution for the last 24 months in QlikView

evolution for the last 24 months

master_student — Sun, 19 Feb 2017 13:00:11 GMT

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

Re: evolution for the last 24 months

vinieme12 — Sun, 19 Feb 2017 15:12:42 GMT

read this post

Dates in Set Analysis

Re: evolution for the last 24 months

Anil_Babu_Samineni — Sun, 19 Feb 2017 15:37:53 GMT

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

Re: evolution for the last 24 months

Anonymous — Sun, 19 Feb 2017 19:36:28 GMT

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

Re: evolution for the last 24 months

master_student — Mon, 20 Feb 2017 09:13:10 GMT

Thank you Samane, will try and let you know