topic Re: Pivot Particial Sum Mistake in QlikView

Pivot Particial Sum Mistake

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

Hi All,

I have a pivot table and some values as shown below. I have made Show Particial Sum from Presentation tab.

But ifit is possible, I want to not sum if value is zero at Sum2.

So My Total sum at Sum1 must be 1200, not 1500.

Is it possible? Could you please help me.

Thank you in advance.

Fatih,

Best Regards.

sunny_talwar — Wed, 30 Nov 2016 12:53:31 GMT

May be like this

If(Dimensionality() = 0, Sum({<a = {"=Sum(Sum2) <> 0"}>} Sum1), Sum(Sum1))

fatihtomruk — Thu, 01 Dec 2016 04:34:05 GMT

Thank you Sunny,

But where can I write this formula? I have written to the Expression but it is wrong as below.

Anonymous — Thu, 01 Dec 2016 04:48:20 GMT

Hi Faith,

You have to write this formula in following way

Dimension:- a

Expression 1(Sum1):- If(Dimensionality() = 0, Sum({<a = {"=Sum(Sum2) <> 0"}>} Sum1), Sum(Sum1))

Expression 2(Sum2):- sum(Sum2)

Please find attached QVW for more details.

Thanks,

Anil_Babu_Samineni — Thu, 01 Dec 2016 04:50:39 GMT

Take Dimension as a and Use Expression for

Dim

Expressions

Sum1 -- If(Dimensionality() = 0, Sum({<a = {"=Sum(Sum2) <> 0"}>} Sum1), Sum(Sum1))

Sum2 -- Sum(Sum2)

And check, It seems this

Anonymous — Thu, 01 Dec 2016 04:50:49 GMT

Hi Faith,

Above formula will give you following result:

Thanks,

fatihtomruk — Thu, 01 Dec 2016 05:02:20 GMT

Thank you all of you. It works. Well-done