topic Re: Calculation in pivot chart in QlikView

Calculation in pivot chart

fashid — Mon, 16 Mar 2015 07:23:44 GMT

Hi Folks,

I have a calculation to implement in pivot chart .

In the last Column of the pivot i need to calculate the reciprocity ratio in 2015 - reciprocity ratio in 2014.

The reciprocity ratio is calculated by the expression =Column(1)/Column(2)

The problem is cannot calculate it using column function.

I know i can write another expression for that but is it possible to get it with the column function.

I am attaching a screenshot of the pivot table.

Thanks &Regards,

Nadeem

Mon, 16 Mar 2015 07:36:10 GMT

Hi ,

Use Like this (check Attached Application)

fashid — Mon, 16 Mar 2015 08:06:57 GMT

Hi,

Thanks for replying vimlesh.

But I do not want like that .It should stay in the same format as i have attached in the screenshot.

That is the issue i am facing .

And also how do i calculate the last column ie recirprocity ratio

Regards,

Nadeem

Mon, 16 Mar 2015 08:36:11 GMT

Dear,

I don't think that in running time you can substract one column from another column (because that is not exit in reality)

You can do like this ,

i am attaching file.

may be help this.

Regards

Vimlesh

fashid — Mon, 16 Mar 2015 10:34:12 GMT

Hi Vimlesh ,

I have attached the sample app.

Thanks for all the help.

Regards,

Nadeem