Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Valued Contributor II

Distribution of specific % of value and add it to specific value

Hi Friends ,

I have a situtation  , see below data

Sample Data.png

I dont want to show I priority in my dashboard , but value of I should be distribute like below

41% of I should add to A

59% of I should add to B

and for other dimensions like zone or some others , it should not happen , and i want to make pivot table for that .

How can i approach this solution.

Attaching  sample data