Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
omyahamburg
Creator II
Creator 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
Partner - Specialist
Partner - Specialist

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

View solution in original post

4 Replies
SunilChauhan
Champion II
Champion II

in second column

use

above(column(1))

Sunil Chauhan
omyahamburg
Creator II
Creator II
Author

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
Partner - Specialist
Partner - Specialist

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
Partner - Specialist
Partner - Specialist

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