Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

CALCULATED FIELD IN PIVOT

Hi,

I am fairly new to Qlikview and am looking for your help in fixing a challenge with pivot table. I have created a pivot table in one of my reports and now I need to create a calculated field.  Sample -

   

COUNTRYPROMOTERSDETRACTORSPASSIVES
CHINA200220202038
AUSTRALIA203620542072
UK207020882106
USA210421222140

Where Promoter, Detractors & Passives are values of one of the fields. What I essentially need is to create a new calculated column that should be  (Promoter - Detractors) / Sum(Promoter, Detractors & Passives).

Any help will be really appreciated.

Thanks,

Ritesh

12 Replies
Anonymous
Not applicable
Author

Hello Sunny,

This doesn't seem to be working for me. Please refer to the attached file.

I am unable to use the file you have shared as I am using personal edition. Please help !

Thanks,

Ritesh

sunny_talwar

Two things

1) Use just one expression here

Capture.PNG

2) Enable partial sub totals for your 2nd dimension

Capture.PNG

After those 2 changes, I get this

Capture.PNG

varunamin
Contributor III
Contributor III

Hi Sunny, Your post was very helpful. Using that I was able to create one calculated column in pivot table but how can I show 2 calculated columns in pivot table. Please let me know if that's possible. Thanks!