topic Re: why the partial sum is not showing in QlikView

why the partial sum is not showing

Sun, 17 Mar 2013 12:57:05 GMT

Subtal is not being showen correctly. I dont have idea whats going wrong. Any one has idea. File is attached.

Re: why the partial sum is not showing

Sun, 17 Mar 2013 14:35:49 GMT

not sure if I understand correctly what you are trying to achieve with aggr, but when you simplify the expression to "Count( DISTINCT PersonID)" it seems to work fine. if you want to then see the zeroes for the products where there are no data points, just untick presentation --> suppress zero-values.

is this what you were looking for?

Re: why the partial sum is not showing

Mon, 18 Mar 2013 06:36:44 GMT

in count actualy I want the number of all doctors in that specialty. like in gen there are 4 doctors and in ENT 5 and 4 should not change even if we select some product.

Re: why the partial sum is not showing

Mon, 18 Mar 2013 06:43:31 GMT

Hi altaf,

PFA, Hope needful has been done.

Regards,

Nirmal.

Re: why the partial sum is not showing

Mon, 18 Mar 2013 06:56:55 GMT

Thanks for Nirmal.. but value itself in count is wrong it should be 4 and 5 but in your chart its showing 16 and 25.

Re: why the partial sum is not showing

Mon, 18 Mar 2013 07:03:48 GMT

PFA...Check now

Re: why the partial sum is not showing

Mon, 18 Mar 2013 07:15:53 GMT

with this data value for all product is 4 and 5 and subtotal should be 9.

Re: why the partial sum is not showing

Mon, 18 Mar 2013 07:28:07 GMT

now check hope values are shown exact.

Re: why the partial sum is not showing

Mon, 18 Mar 2013 07:54:41 GMT

for product p2 values are incorect and secondly product selection is not working.

Re: why the partial sum is not showing

Mon, 18 Mar 2013 08:03:38 GMT

ya for p2 count is 3 only na

Re: why the partial sum is not showing

Mon, 18 Mar 2013 08:27:31 GMT

for this count is also 4 and 5.

Let me explain more .. it is number of person in that speciality irrespective of product.

Re: why the partial sum is not showing

Mon, 18 Mar 2013 08:46:21 GMT

doesn't count(PersonID) give you the required answer?

Re: why the partial sum is not showing

Mon, 18 Mar 2013 08:55:19 GMT

plz check your values altaf because from my end values are matching for p1=(ent=4,gen=5),p2=(ent=0,gen=3),p3=0,p4=0 this is the values are shown for me these are validated also. but you said that was wrong. When i selsct p3 & p4 no values are selected in person id list box. whaen i select p2 person id shows 3 count and p1 shows 9 values in person id list box. plz check and revert back

Re: why the partial sum is not showing

Mon, 18 Mar 2013 10:09:58 GMT

Thank for your time and help.. as explain in chart number is shown below the product but actualy it does not depend on the product. its simple no of person in specialty.

Re: why the partial sum is not showing

Mon, 18 Mar 2013 10:17:33 GMT

ok, I think I'm beginning to understand what you want to achieve. is it this?

If it is, you need the TOTAL qualifier to tell the expression to ignore dimensionality of the chart. however, you only want to ignore one of the dimensions (product) but consider the other (specielity), so your forumla should look like:

Count( DISTINCT TOTAL <Specielity> PersonID)

Re: why the partial sum is not showing

Mon, 18 Mar 2013 10:17:36 GMT

ok You got the Answer?

Re: why the partial sum is not showing

Mon, 18 Mar 2013 11:52:39 GMT

no, still looking for.

Re: why the partial sum is not showing

Mon, 18 Mar 2013 11:55:33 GMT

Can you tell me your actual requirement

Re: why the partial sum is not showing

Mon, 18 Mar 2013 12:08:45 GMT

Why you wrote NoDistinct in expression

Re: why the partial sum is not showing

Mon, 18 Mar 2013 12:15:25 GMT

Ya sure..

my requirement is

Producut1 Producut2

Total 9 (sum of this column i.e 4 +5) 9 (sum of this column i.e 4 +5)

Speciality1 4(no of person in Speciality1 ) 4(no of person in Speciality1 )

Speciality2 5(no of person in Speciality2 ) 5(no of person in Speciality2 )

you question would be that why I am including product. its answer is that because I need other calculation related to specifice product therefore including product.