Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

columns with percentage values in pivot tables

Hi all,

when working with pivot tables,I often liked to add some some columns with percentage values.

For example, now I have this:

1.png

but I would like to have something like this:

2.png

Does anyone knows if is it possible?

Thank you!

Sofia Vaz

11 Replies
ychaitanya
Creator III
Creator III

Can you elaborate the problem here.

Have you tried adding the expression for %?

shiveshsingh
Master
Master

Please share ur app and data, it's possible i think.

Anonymous
Not applicable
Author

sum(dimension) / sum(total dimension)

Mark the dimesion wtih Show Partial Sums in the  Presentation!

Anonymous
Not applicable
Author

Thank you Shivesh. I'm not able to share app or data...

Anonymous
Not applicable
Author

Thank you Antonio.

I've add the % expression as a measure. Do you know if there's a way to present the results only for the Total lines? I don't need to present them to for all the cases, as it is now...

As it is now:

3.png

As I would like it to be:

2.png

Thank you!

Anonymous
Not applicable
Author

Hi Chaitanya.

I've add the % expression as a measure. Do you know if there's a way to present the results only for the Total lines? I don't need to present them to for all the cases, as it is now...

As it is now:

3.png

As I would like it to be:

2.png

Thank you!

olivierrobin
Specialist III
Specialist III

hello

try to use dimensionality()

something like that in your column

if(dimensionality()=1,sum(...),'')

Anonymous
Not applicable
Author

Hi Olivier,

I'd never used dimensionality() before, so I may not understanding this very well.. What I've tried was to change the % expression to this:

if(Dimensionality()=1,(sum({<OrdMasterOrdDateYear={"$(=vYearToday)"},OrdMasterOrdDateWeekYear={$(=vLastOrdMasterOrdDateWeekYear)},OrdItemMillAlloc *={'ATF','FIG','SET'}, OrdItemProdCd={*}-{'SHT'},OrdMasterOrdType={'CUST','STOCK-WHSE'}, OrdItemOrdStat={'CONFIRM','COMPLETE','HOLD'}>}if(OrdItemDelDate<>OrdMasterOrdDate, OrdItemOrdKgs))/1000)/(sum(TOTAL{<OrdMasterOrdDateYear={"$(=vYearToday)"},OrdMasterOrdDateWeekYear={$(=vLastOrdMasterOrdDateWeekYear)},OrdItemMillAlloc *={'ATF','FIG','SET'}, OrdItemProdCd={*}-{'SHT'},OrdMasterOrdType={'CUST','STOCK-WHSE'}, OrdItemOrdStat={'CONFIRM','COMPLETE','HOLD'}>}if(OrdItemDelDate<>OrdMasterOrdDate, OrdItemOrdKgs))/1000

   

),"")

   

but the output is this, not exactly what I wanted:

4.png

olivierrobin
Specialist III
Specialist III

oups  !!! sorry

use secondarydimensionality()

it works the same way but on columns