Discussion Board for collaboration related to QlikView App Development.
I have a dimension which is restricted and thereby doesn't show everything.
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?
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
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