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

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

Wed, 20 Nov 2013 06:21:14 GMT

ex:

eo/p should be like this

Anonymous — Wed, 20 Nov 2013 06:34:05 GMT

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

sujeetsingh — Wed, 20 Nov 2013 06:51:12 GMT

See the sample and also go to the script for it