Each year separate chart from many years data

[#1]

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

[#2]

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.

[#3]

Thank you very much

[johnw]

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.