topic Re: partial sum showing zero in QlikView

partial sum showing zero

sajad_manzoor — Wed, 04 Sep 2013 05:05:15 GMT

Hello Gurus,

I am using following expression in pivot chart

"IF( EstimatedEndDate>= vStartDate and EstimatedEndDate <= vEndDate ,sum([Milestone Revenue in INR (TR)]),0)"

but the partial sums are showing 0

Please suggest.

Also , how can i write the same expression using set analysis...

tresB — Wed, 04 Sep 2013 05:07:53 GMT

Change the total mode to Sum of rows and check

sajad_manzoor — Wed, 04 Sep 2013 05:15:14 GMT

Hi Tresesco,

this works only in straight table ,but when i use pivot chart, even no partial sum row is shown,

the partial sum property is checked for EstimatedEnd

tresB — Wed, 04 Sep 2013 05:19:11 GMT

In the presentation tab 'Show Partial Sums' is there, you have to check/tick.

sajad_manzoor — Wed, 04 Sep 2013 05:23:37 GMT

'Show Partial Sums' check box is checked

tresB — Wed, 04 Sep 2013 05:37:31 GMT

It is possibly because of you are using a calculated dimension or an expression which is complex. Please post a sample.

Anonymous — Wed, 04 Sep 2013 06:03:58 GMT

Hi,

1. use a text box object paste / write your expression there see is is showing 0 there if yes then there is

problem in your expression.

2. if expression show values and does not show zero then go to presentation tab check whether you checked both

dimension ie project code and estimated end date as partial sum.

regards,

anant

spividori — Wed, 04 Sep 2013 12:44:56 GMT

Hi.

Try:

sum(IF( EstimatedEndDate>= vStartDate and EstimatedEndDate <= vEndDate ,[Milestone Revenue in INR (TR)]))

Regards.