topic Re: Total Value / Individual Value in QlikView

Total Value / Individual Value

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have one requirement like :

Percent Sum = Total Sales / Individual Sales.

for the 1st row it would be: 622779.66 *100 / 11020269.20

It should be 5.65 %, however it is coming like 0.60 %.

Could anyone please suggest on this.

I am attaching my app.

MindaugasBacius — Wed, 03 May 2017 07:55:56 GMT

Do something like this:

=Sum(Sales)/Sum(TOTAL Sales)

mhmmd_srf — Wed, 03 May 2017 08:07:48 GMT

Hi Bacius,

This expression is already there. Still not working.

Please help.

Thanks,

Sarif

antoniotiman — Wed, 03 May 2017 08:20:23 GMT

Maybe

tresB — Wed, 03 May 2017 08:22:58 GMT

Null values in dimension are causing the problem. Try expression like:

=sum(ContarctSales)

/ sum(total if (not IsNull(DIM_ITEM.GroupMajorDescription), ContarctSales))

mhmmd_srf — Wed, 03 May 2017 08:29:16 GMT

It is working..thanks..

mhmmd_srf — Wed, 03 May 2017 08:29:55 GMT

This is woeking..thanks..

But could you please let me know hoe this property works.

Thanks,

Sarif

antoniotiman — Wed, 03 May 2017 08:37:38 GMT

This works for Straight Table (Not Pivot)

Provide Rate of Row / Total Column

Regards,

Antonio

antoniotiman — Wed, 03 May 2017 08:42:29 GMT

Indeed You need only

Sum(Sales) and Check Relative.