topic Pivot Table in QlikView

Pivot Table

marco_puccetti — Mon, 13 Apr 2015 08:58:10 GMT

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

Re: Pivot Table

robert_mika — Mon, 13 Apr 2015 09:20:41 GMT

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

Re: Pivot Table

marco_puccetti — Mon, 13 Apr 2015 09:54:34 GMT

I have attached the screenshot.

Thanks

Re: Pivot Table

Anonymous — Mon, 13 Apr 2015 10:04:32 GMT

Numbering start within the expression window.

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

Re: Pivot Table

marco_puccetti — Mon, 13 Apr 2015 12:11:14 GMT

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

Thanks

Re: Pivot Table

Anonymous — Mon, 13 Apr 2015 12:25:00 GMT

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

Re: Pivot Table

marco_puccetti — Mon, 13 Apr 2015 12:31:47 GMT

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

Thanks

Marco

Re: Pivot Table

Anonymous — Mon, 13 Apr 2015 13:32:41 GMT

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

Re: Pivot Table

marco_puccetti — Mon, 13 Apr 2015 13:55:32 GMT

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

Thanks

Re: Pivot Table

awhitfield — Mon, 13 Apr 2015 14:12:02 GMT

Hi Marco,

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

Andy

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

Re: Pivot Table

Anonymous — Mon, 13 Apr 2015 15:01:05 GMT

Apologies for the late reply.

Please find attach the solution to your problem

You cannot use Column() with dimensions

You can use after() function though.