topic How to display budget figures in QlikView

How to display budget figures

omyahamburg — Wed, 09 Nov 2011 06:23:44 GMT

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.

SunilChauhan — Wed, 09 Nov 2011 08:09:50 GMT

in second column

use

above(column(1))

omyahamburg — Wed, 09 Nov 2011 08:42:56 GMT

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 — Thu, 10 Nov 2011 07:27:33 GMT

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 — Thu, 10 Nov 2011 09:28:48 GMT

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