Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

philgood34
Contributor II

CALENDAR MEASURE YTD Last Year

Hi

To explain my issue i created a simple sample ;

I have 2 files with common dates (3 years ) as shown

fichiers.png

Then I created  a calendar measure on CATTC field

measures.png

So now, i want to  create a graph with comparative analysis CATTC historical / real / goal  over th entire periode (obviously 2 years about the historical)

I obtain that

graph.png

my issue :

CATTC real = CATTC last Year on 2016

No CATTC historical on 2017

as you see, i don't understand the basic concept :-(

I need some help

regards

Philippe

1 Reply
philgood34
Contributor II

Re: CALENDAR MEASURE YTD Last Year

Hi everybody

Let me add another visualisation to illustrate my issue.

here i only selected Year 2016

GRAPH 2.png

as you see, year and last year are strictly equal (year value)

i didn't change the automatic expression below

expression.png

May be should I ???

don't understand :-)

regards

Philippe

Community Browser