Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

why the partial sum is not showing

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

Tags (1)
20 Replies
Not applicable

Re: why the partial sum is not showing

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.

Capture.JPG

is this what you were looking for?

Not applicable

Re: why the partial sum is not showing

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.

Not applicable

Re: why the partial sum is not showing

Hi altaf,

PFA, Hope needful has been done.

Regards,

Nirmal.

Not applicable

Re: why the partial sum is not showing

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.

Not applicable

Re: why the partial sum is not showing

PFA...Check now

Not applicable

Re: why the partial sum is not showing

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

Not applicable

Re: why the partial sum is not showing

now check hope values are shown exact.

Not applicable

Re: why the partial sum is not showing

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

Not applicable

Re: why the partial sum is not showing

ya for p2 count is 3 only na

Community Browser