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

Create a field in a pivot table

Wed, 08 Aug 2012 21:34:06 GMT

Hello, I have a problem, ¿How can I create personalized calculations or subtotals in a pivot table?

For example, let's assume we have a dimension "month" (columns) and a dimension "Age Range" (rows). For age range the possible values are "child", "teenager", "adult" and "senior", I would like to sum only "child" and "teenager" to create a row named "Total Young people". How can I do this?

Thanks you, regards!

Re: Create a field in a pivot table

IAMDV — Thu, 09 Aug 2012 16:16:34 GMT

Please check the Dimensionality() function. This function returns 0 for the Total field and you can write your expression with string concatenation.

For example your expression :

Sum(People)

Then you can write :

IF(Dimensionality() = 0, 'Total Young people : '& Sum(People), Sum(People))

You can expand this logic by implementing Pick() & Match() to pickup the field name.

Cheers,

www.QlikShare.com

Re: Create a field in a pivot table

Thu, 09 Aug 2012 17:03:46 GMT

Hello, It didn't work with the Dimensionality() function :s

Re: Create a field in a pivot table

IAMDV — Thu, 09 Aug 2012 17:45:29 GMT

Please can you post the sample application?

Thanks,

www.QlikShare.com

Re: Create a field in a pivot table

Thu, 09 Aug 2012 18:08:59 GMT

It's the PRM Table, thanks

Re: Create a field in a pivot table

Fri, 10 Aug 2012 04:05:34 GMT

An example with excel here that show what exactly I want. I have three files, Separations, LeaversOwnDecision and Joiners, and two calculated files, partial and total variation. That is exactly that I want in Qlikview, create the two new values for the dimension "Recruit/Termination", exactly how you can see in excel table.

Regards.

Re: Create a field in a pivot table

whiteline — Mon, 03 Sep 2012 14:26:05 GMT

You can use similar trick:

http://community.qlik.com/message/252646