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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Percentage

Hi,

I have this dynamic table with a percentage (60%) for the sub-total of "Line 1" which I want to apply on the lines where designation='COMMUNS'.

I have tried many things but couldn't do it.

Any one has an idea ?

Labels (1)
1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

See attached example.


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Not applicable
Author

I don't understand your need.

Could you post an excel with what you want ?

hirenjadiya
Partner - Contributor III
Partner - Contributor III

Hi

Try using variable. Assign SUM(TOTAL([Comptany 1]+[Comptany 2]+[Comptany 3]+CommunsTO some variabe

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

See attached example.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

Thanks Gysbert !