Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Hi, how to do % calculation over dimension in pivot table, please help ASAP.

ex:

                                               

StatusWeekW1W14W13W28
Deleted 2504700819240
Pending 20432--
Proposal
  Submitted
15634465483399599
Total 18342535883589839


eo/p should be like this

StatusWeekW1W14W13W28
Deleted 2504700819240
Pending 20432--
Proposal
  Submitted
15634465483399599
% Submitted 85
Total 18342535883589839
2 Replies
Highlighted
Specialist
Specialist

Re: Hi, how to do % calculation over dimension in pivot table, please help ASAP.

do the following

1. add dimensions like Status , deleted,pending,proposal submitted to your table

2. in expresioon tab  [Proposal submitted] / [Submitted]  (remember it should be in blue color which is correct)

3. go to Number tab select Radio button Integer and mark check box show in percent .

anant

Highlighted
Master III
Master III

Re: Hi, how to do % calculation over dimension in pivot table, please help ASAP.

See the sample and also go to the script for it