Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
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 :

Capture.JPG

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

4 Replies
vinieme12
Champion II
Champion II

read this post

Dates in Set Analysis

Anil_Babu_Samineni

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)
samane_ramezani
Creator
Creator

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

master_student
Creator III
Creator III
Author

Thank you Samane, will try and let you know