Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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.

View solution in original post