Percent is incorrectly calculated in a pivot table in Qlik Sense. Feb 2018 is fine because it shows 100% in total but in March 2018 the total shows 1000%. When I change the format to number without % than March 2018 value total is 10 instead of 1as expected.
Would you have already experienced this behaviour and would get a solution? Thx.
Re: Sum of Market share gives 1000% instead of 100%
Yes two expressions are used. 1 for the chosen current period and the other for the referenced period. The user gets the ability to select in a drop down list the relative time period. In this example the chosen period is Month vs. Month-1.