Pivot Table

[marco_puccetti]

Hello i need a table made of these field:

Abi | Anno | Anno Prec | Delta%

I have used the column() function but it doesn't work properly, infact if i add the delta field in the expression section it adds a column per year like this:

Abi | Anno | Delta % | Anno Prec | Delta %

How can i solve this question?

Thanks

Marco

[robert_mika]

Could you add your data/file and what is not working?

[marco_puccetti]

I have attached the screenshot.

Thanks

[Anonymous]

Numbering start within the expression window.

i.e. importi is your column 1 and Delta% your columnn 2

[marco_puccetti]

For Column(1) it works, but for further columns it doesn't show the correct result.

Thanks

[Anonymous]

In the above expression for Delta%, what do you mean by Column(4) and Column(3) ?

[marco_puccetti]

I need the delta percentage between two year; the year field is dynamic (is a table field).

Thanks

Marco

[Anonymous]

What will the formula for Delta% for Year 2014? Can you give me an example. The requirement is still not clear to me.

[marco_puccetti]

The formula is the amount of data for 2015 minus 2014 divided the amount for year 2014.

Thanks

[awhitfield]

Hi Marco,

check out the attached post, it deals with a very similar issue to yours.

Andy

https://community.qlik.com/message/708412#708412