Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Each year separate chart from many years data

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

Tags (1)
3 Replies
Not applicable

Each year separate chart from many years data

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.

Not applicable

Each year separate chart from many years data

Thank you very much

MVP
MVP

Each year separate chart from many years data

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.

Community Browser