Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
agni_gold
Specialist III
Specialist III

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

0 Replies