So when creating pivots for my users in Qlik Sense SaaS I have had several requests for a custom calculation which presents itself in the same way as the 'Totals' with the 'Show Totals' feature. Example, say a "Pass %" by months is needed with the dimension of status showing Pass and Fail and counts. Today I could just show the Total Pass and Fail counts on the two rows by month but not a Pass % each month in the pivot instead of just the Total. If there was a way to have the 'Show Totals' feature allow for a custom expression with set analysis that would open up a lot of flexibility for that 'Show Totals' option.
NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.
