Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jvleensel
New 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

Re: Sum of Market share gives 1000% instead of 100%

What expression are you using?

jvleensel
New Contributor II

Re: Sum of Market share gives 1000% instead of 100%

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,

Re: Sum of Market share gives 1000% instead of 100%

You have two expressions in the chart or just one?

jvleensel
New Contributor II

Re: Sum of Market share gives 1000% instead of 100%

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,

Re: Sum of Market share gives 1000% instead of 100%

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

Capture.PNG

Community Browser