topic Each year separate chart from many years data in QlikView

Each year separate chart from many years data

Wed, 10 Jun 2009 01:36:10 GMT

I loaded the data for more than 3 years; I have field =year which has 2007,2008,2009; How I can have 3 different chart for different years; Chart 2007, Chart2008, Chart2009; where I can put conditions or filter to sum(salesamt) for different years. I am new to qlikview. Thanks

Each year separate chart from many years data

Wed, 10 Jun 2009 02:01:17 GMT

Your question is pretty abstract and there are multiple ways to handle it.

Perhaps the best way is using Set Analysis. In your chart expressions, you want to use Sum( salesamt ). To get that value for a certain year using Set Analysis, you want: Sum( {<Year = {2007}>} salesamt). The portion in the curly brackets is the Set Analysis and basically means that if the Year = 2007, then do the sum.

Each year separate chart from many years data

Wed, 10 Jun 2009 02:26:46 GMT

Thank you very much

Each year separate chart from many years data

johnw — Wed, 10 Jun 2009 05:10:01 GMT

Although I'm not in the version 9.0 beta testing, my understanding is that it will allow you to generate the same chart for each value of the same field. I believe reports allow you to do that now in version 8.5, but that doesn't do much good when you're trying to make a nice screen.

I've done it with set analysis in the past, as NMiller suggested.