Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have a similar pivot table below. On the first colum are 2 expressions all the headers repesent the dimension year
Expressions | 2008 | 2009 | 2010 | 2011 | 2012 |
---|---|---|---|---|---|
sum (investments) | 180.000 | 178000 | 152.000 | 104.884 | 93.021 |
sum (investments) - (expenses) | 170.000 | 168.000 | 148.000 | 100.000 | 90.000 |
Difference between next year? | 2000 | 20.000 | 48.000 | 10.000 | - |
Now I would like to create an expression that does the following:
sum (investments) - (expenses) of 2008 - sum (investments) - (expenses) of 2009 (170.000 - 168.000) = 2000
sum (investments) - (expenses) of 2009 - sum (investments) - (expenses) of 2010 (168000 - 148000)=20.000
sum (investments) - (expenses) of 2010 - sum (investments) - (expenses) of 2011 (148000 - 100.000)=48.000
sum (investments) - (expenses) of 2011 - sum (investments) - (expenses) of 2012 (100.000 - 90.000)= 10.000
Is this possible within Qlikview?
Thanks in advance!
Carter.
i mean try function below()
you dont need to do it by pivot table (try straight and horizontal view)
as for your question ... try function above()
your expression should look :
=sum(investments-expenses)-Below(sum(investments-expenses))
i mean try function below()
Many Thanks ! Below and straight table using horizontal view, did the job!
Carter