Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Fixing percent

I have a dimension which is restricted and thereby doesn't show everything.

Current formula:

Sum (Antall)/Sum (TOTAL(Antall))

However this formula yields percentage based upon every number in the dimension. Can this be adjusted so it only calculates from the shown rows?

1 Solution

Accepted Solutions
Not applicable
Author

Only with the Sum(Antall), If you check the 'relative' option, the graph will show the percentages of the shown rows.

View solution in original post

2 Replies
er_mohit
Master II
Master II

try this

Sum (Antall)/Sum (TOTAL Antall)

and in number tab for this expression

fixed to 2  and check on show in % if you want otherwise Uncheck it

Not applicable
Author

Only with the Sum(Antall), If you check the 'relative' option, the graph will show the percentages of the shown rows.