topic Different year in graph in QlikView

Different year in graph

Fri, 02 Sep 2011 07:40:59 GMT

I would like to make a graph where different year is presented by each line in the chart.

I count number of incomming invoices each year.

on the x-dimension i have months

on y- dimension i have the sum

In th table where i count the number of invoices i have a collumn with the HistoryDate, se picture below.

Different year in graph

its_anandrjs — Fri, 02 Sep 2011 07:45:08 GMT

Hi,

You need to create a seperate expression for the years.

Regards

Anand

Re: Different year in graph

Fri, 02 Sep 2011 07:51:00 GMT

How do you mean. I have to seperate the year in the history table?

Like this?

And then use a set expression?

Re: Different year in graph

Fri, 02 Sep 2011 08:00:36 GMT

The solution was like its.Anandrjs said: Split the date field so that year is displayed in a seperated collumn then I used the set analysis for each expression:

Sum ( { [ HistoryYear1 ] = { ' 2011 ' } > } ) Historycount)