Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jvleensel
Partner - Contributor II
Partner - Contributor II

Sum of Market share gives 1000% instead of 100%

Hi,

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.

5 Replies
sunny_talwar

What expression are you using?

jvleensel
Partner - Contributor II
Partner - Contributor II
Author

Hi Sunny,

here the expression I use:

sum( {$<$(vPeriod)>}$(vMeasure))/ sum(total {$<$(vPeriod)>}$(vMeasure))

    &

sum( {$<$(vReferencePeriod)>}$(vMeasure)) / sum(total {$<$(vReferencePeriod)>}$(vMeasure))

Where vPeriod = March 2018, vReferencePeriod = February 2018 and vMeasure = Units

Thanks,

sunny_talwar

You have two expressions in the chart or just one?

jvleensel
Partner - Contributor II
Partner - Contributor II
Author

Hi Sunny,

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.

Regards,

sunny_talwar

I mean which of the two expressions are giving you problem here?

Capture.PNG