Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Line chart - % between years

Hi everyone.

Here's my problem : I want to know the percentage between all the years for one data.

In my pivot table, I have no problem, but when I try to put it in a line chart, there are some issues.

I have two dimensions : all the activities and the year.  (in this order)

YearActivitysum(Prices)
2011Swimming pool1.000
2012Swimming pool1.100
2013Swimming pool1.000
2011Dojo2.000
2012Dojo 2.200
2013Dojo2.420

So, I want that my line chart has 2 lines, the first one for the swimming pool, for which in 2012, it shows +10%" and in 2013 -"10%" and for the dojo 2012:'+10%' and 2013 "+10%".

I tried to create the following expression : sum(Prices)/above(sum(Prices))-1, but it doesn't work.

wrong numbers.png

(niv_3 = activities)

But when I switch the dimensions ( Year - activity), it gave me the right numbers, except that the dimensions are inversed.good numbers.png

Can someone help me please ?

Thanks a lot !

1 Reply
Not applicable
Author

Sorry to up it, but does someone can help me ? Or maybe had I bad explained my problem ?