topic Re: Create a field in a pivot table in QlikView

Create a field in a pivot table

Tue, 31 Jul 2012 22:37:41 GMT

Hello, I have a question about how create calculated fields on a pivot table.

The table that I have is this:

That I need it, is a substraction of the field Joiners with the other fields, in other words, this: (Joiners - LeaversOwnDesicion - Separations), and create a new field in the same table that show that substraction with the name "Movement Total".

Other thing that I need is show the percentaje of the months for years, for example, in the same table put a field with the name "2011" (that year is in the model and data of .qvw), and show the percentaje of the field "Joiners" and "Movement Total" , calculate from a immovable value, for example, 150.

I attach the .qvw fiel with my model if someone can help me. I only have Personal Edition, I won't can see your files, so I would so glad if you can wrote the code or show me a image.

Beforehand, thanks you for you answers

Re: Create a field in a pivot table

Tue, 31 Jul 2012 22:46:21 GMT

Assuming your current expression is:

Count(Employee)

You can try the below one:

Fabs(Count({<AttritionReport={"Joiners"}>} Employee)-Count({<AttritionReport-={"Joiners"}>} Employee))

Kiran Rokkam.

Re: Create a field in a pivot table

Tue, 31 Jul 2012 22:48:15 GMT

Thanks, this code is going to on the report or in the script?, regards

Re: Create a field in a pivot table

Tue, 31 Jul 2012 22:49:24 GMT

In the chart. You would notice change in the total row of the chart.

Kiran.

Re: Create a field in a pivot table

Wed, 01 Aug 2012 14:59:34 GMT

I apologize, but I didn't understand where I write the code that you show me, I wrote in the chart, like expression, like dimension, and not work :s.

By the way, my current expression is NumericCount (DISTINCT GlobalEmployeeId).

Regards!

Re: Create a field in a pivot table

Thu, 02 Aug 2012 16:00:10 GMT

Please, exactly in what wpart of the chat is going wrote that code :s, thanks