topic Re: Partial count is not coming proper in QlikView

Partial count is not coming proper

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

I am trying to get correct right generation data in my project.the total sum of generation is coming right but when i am selecting single state in my project as dimension than the generation is coming wrong.

this is total installed capacity which is coming right (fig.1)

but in (fig2) when i am select single state like AP then the installed capacity is not coming right .instead of giving 222.63

it will give 279

the expression used is::SUM(CapacityPerEquipment) / 1000

please help me out .

thanx in advance.

Re: Partial count is not coming proper

sunny_talwar — Mon, 02 Apr 2018 11:48:24 GMT

Would you be able to share your app to look into it?

Re: Partial count is not coming proper

Anil_Babu_Samineni — Mon, 02 Apr 2018 12:54:10 GMT

May be State AP has that values only?

Re: Partial count is not coming proper

Anonymous — Wed, 04 Apr 2018 06:38:04 GMT

when i am performing same task with pivot table than it will give me right result .

as Ap-279 and 222.63

Re: Partial count is not coming proper

Anonymous — Wed, 04 Apr 2018 06:52:14 GMT

The size of application is too large.

i want to know that when i am perfoming same task with pivot chart the result is coming right but when it is performed with gauge chart then it is giving me wrong ans .

for Eg:

Pivot chart:

selecting state AP it gives 279 and 222.63

but in gauge chart for AP it gives 279 and 276

expression was same for both chart::: SUM({<IsAvailable={1}>}CapacityPerEquipment)/1000

Re: Partial count is not coming proper

sunny_talwar — Wed, 04 Apr 2018 09:00:30 GMT

May be this link can help you address the size concerns

Preparing examples for Upload - Reduction and Data Scrambling