Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
mmitteregger
Contributor
Contributor

Create Last Column in PivotTable

Hello Community!

 

Is it possible to get only one column and sum all columns in front of in a pivot-Table? Thanks in advance!

 

Br

Mike

3 Replies
saminea_ANZ
Creator
Creator

can you please brief about it?

mmitteregger
Contributor
Contributor
Author

Hy!

 

I have a pivot-Table with 5 dimensions and 1 summarized field. i need one more field that calculates an Percentages about two fields.

 

Br

Mike

saminea_ANZ
Creator
Creator

May be this?

Num(Sum(TOTAL <Field1, Field2> Measure),'#,#0%')

Or

Num(Sum(Aggr(Sum(Measure), Field1, Field2)),'#,#0%')