topic Re: Adding custom column to pivot table in App Development

Adding custom column to pivot table

Anonymous — Wed, 15 Aug 2018 14:31:08 GMT

Hi everyone.

I would like to convert the Delivery Costs/Sales row into a new column in the pivot table below so the percentage value is displayed right next to the delivery costs value. It could be even in the same cell as the delivery costs value. For instance, it would show R$ 150,00 (1,24%).

The Sales and DeliveryCosts come from different tables and both are associated to another table through ClientID.

It seems both options are easily doable, but I am unable to solve it. I wouldappreaciate any help!

Re: Adding custom column to pivot table

undergrinder — Thu, 16 Aug 2018 08:36:34 GMT

Hi Renan,

It seems that you swap the Clients/Valores will do the work.

Re: Adding custom column to pivot table

BalaBhaskar_Qlik — Thu, 16 Aug 2018 13:10:06 GMT

Drag and drop of columns, it'll make values as Individual columns.

You can use Crosstable load in script.

Declare field with this value as Individual one, use that in Pivot table.

Re: Adding custom column to pivot table

Anonymous — Thu, 16 Aug 2018 16:47:23 GMT

Hey Gabor,

That sets all my current rows as columns, in a way that all my values are side to side to each other, but I want only the Delivery Costs/Sales as a column.

Re: Adding custom column to pivot table

Anonymous — Thu, 16 Aug 2018 17:02:30 GMT

Hey Bala,

I have tried all possible drag and drop combinations without success so far.

The Delivery Costs/Sales value was created through a chart function.

I'm not sure how to implement the second option you suggested. Ideally, I would make this calculation in my excel files and just choose to show them in my pivot table as a new column. But the two values needed for the calculation come from different workbooks. I thought it would be easier to do it on Qlik Sense, but my knowledge is limited.

Re: Adding custom column to pivot table

Anonymous — Fri, 17 Aug 2018 14:43:06 GMT

I found a thread in which someone has the same issue. Perhaps they explained better what we want.
Re: Pivot Table Column