topic Re: Bar and Line Series in same Chart in QlikView

Bar and Line Series in same Chart

Thu, 04 Jul 2013 20:55:27 GMT

In top chart I am trying to show the 2010/11 value as Bar chart and the rest as line chart.

I manage to achive this using the set operators (Avg ({$<FinYear = {[2010/11]}>}LoSLoS)) but lost of ability to filter on Finincial year.

I can quite easly acgive this in excel by changing the chart series. However, I was wondering if there is an easy way to do the same in Qlikview

Any help in this regard will be much appricaited.

swuehl — Thu, 04 Jul 2013 21:29:13 GMT

I manage to achive this using the set operators (Avg ({$<FinYear = {[2010/11]}>}LoSLoS)) but lost of ability to filter on Finincial year.

So you are using several expressions instead of one expression and a second FinYear dimension, right?

You can use the intersection set operator to keep your FinYear sensitive to selections:

Avg ({$<FinYear *= {[2010/11]}>}LoSLoS)

Fri, 05 Jul 2013 06:41:10 GMT

Yes, i was using several expressions. One expression for each finincial year

Thank you so much, intersection set operator has solved the problem