Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hope someone might be able to assist with this. We're looking to include some sort of custom report table within our new QlikSense apps (where users can select the visible dimensions and can specify the measure to be used.). The issue we're stuck with is that we want to offer the ability to calculate percentages based on the final field/row total e.g. if a table was displaying data for Divisions and Gender, we'd like to be able to provide percentages totalling 100% for each division. If a user was to then decide they'd like to change columns to Programme and Age Bracket, we'd still like the table to be able to calculate the proportions properly.
In our old Qlikview dashboards, we had a workaround where the user was presented with a pop up list box containing a field list so they could select their desired denominator. This was then fed into a variable which was then called in the following expression:
=count(FTE)/count(total<[$(vPercentageby)]>[FTE])
If possible, we'd like our QlikSense app to automatically pick up the appropriate field as a denominator. Does anyone have any ideas on how to accomplish this?
Any help is most appreciated.
Matt
use GetObjectionDimension()
=count(FTE)/count(total<$(=GetObjectionDimension(1))>[FTE])
I made a typo there it's
GetObjectDimension() not
=count(FTE)/count(total<$(=GetObjectDimension())>[FTE])