Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
rfreire06
Contributor III
Contributor III

Adding custom column to pivot table

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!

pivot table.jpg

5 Replies
undergrinder
Specialist II
Specialist II

Hi Renan,

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

G.

balabhaskarqlik

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

You can use Crosstable load in script.

Or

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

rfreire06
Contributor III
Contributor III
Author

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.

rfreire06
Contributor III
Contributor III
Author

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.

rfreire06
Contributor III
Contributor III
Author

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