Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

omyahamburg
Contributor II

How to display budget figures

Hello all

I am a real beginner here and have a question.

I have a table containing dates and amounts.

In the script I extracted the year of the dates already in a new field.

In a chart I display the sum depending the year I choose.

But how can I display in a second column the sum for the year before ?

I look forward to your help.

1 Solution

Accepted Solutions
kamalqlik
Valued Contributor

Re: How to display budget figures

Hi Joerg,

                    the expression used by me is the example of set analysis.I am sharing the st analysis PDF with you.Hope this will help you....Alll the best buddy

regards

Kamal

4 Replies
SunilChauhan
Esteemed Contributor

How to display budget figures

in second column

use

above(column(1))

omyahamburg
Contributor II

Re: How to display budget figures

Dear Sunil

Thanks for your quick reply.

Unfortunately I am not so familiar with expressions yet.

Could you have a look into the attached application ?

Thank you.

kamalqlik
Valued Contributor

Re: How to display budget figures

Hi Joerg.......I have made correction in your application.Now it is working fine.Check it and if some issue than let me know...

Regards

Kamal

kamalqlik
Valued Contributor

Re: How to display budget figures

Hi Joerg,

                    the expression used by me is the example of set analysis.I am sharing the st analysis PDF with you.Hope this will help you....Alll the best buddy

regards

Kamal