topic Re: Incorrect counts in QlikView

Incorrect counts

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

Dear all,

I am getting the incorrect count in my pivot table.

For example below 14 territories have total 13 activity count but this 13 is reflecting in all the territories. It should be sum total for all.

Re: Incorrect counts

prieper — Fri, 07 Sep 2018 09:38:52 GMT

Go to Properties -> Presentation -> Dimensions and Expressions

choose "Mkt Territory Id" and click to "Show Partial Sums"

HTH

Peter

Re: Incorrect counts

bhuprakash — Fri, 07 Sep 2018 09:44:52 GMT

Hi Peter,

It is not working.

Re: Incorrect counts

prieper — Fri, 07 Sep 2018 09:50:06 GMT

What does not work?

It shows the Sum of 503 in the bottom-line??

Re: Incorrect counts

bhuprakash — Fri, 07 Sep 2018 09:56:58 GMT

territory wise count should come as below. But it is coming wrong in my dashboard.

Marketing Territory	Count of Activity Id
Abohar	11
Achanta	1
Agar	8
Ambala	3
Amod	1
Amreli	1
Arvi	5
Athagad	2
B.Kothakota	1
Badnagar	4
Badnawar	6
Bagepalli	1
Baglan	13
Baleshwar Sadar	2
Barasat - I	2
Bareilly	3
Barpeta	1
Basudebpur	1
Bavla	1
Bemetara	3
Bhadrak Rural	1
Bhanvad	1
Bhuj	1
Binika	3
Biswanath	2
Bongaigaon (Pt)	1
Botad	4
Budhlada	1
Burdwan - I	1
Chakur	2
Challapalle	2
Chandvad	3
Cherukupalle H/O Arumbaka	1
Chhatarpur	1
Chikkaballapura	1
Chilakaluripeta	1
Chinaganjam	1
Chintamani	1
Dabhoi	1
Darsi	2
Deglur	2
Dewas	2
Dhar	1
Dharampuri	7
Dharangaon	1
Dhrol	2
Dhule	1
Diamond Harbour - I	1
Digras	3
Domkal	3
Edlapadu	2
Erandol	1
Faridkot	1
Fatehabad	10
Firozpur	3
Galsi - I	1
Galsi - Ii	1
Gampalagudem	1
Gangakhed	1
Gangapur	4
Giddalur	1
Gollaprolu	3
Gondiya	1
Gudivada	1
Gudlavalleru	2
Halvad	1
Harda	2
Himatnagar	1
Hingoli	1
Hisar	5
Ibrahimpatnam	2
Jafferabad	1
Jagadhri	3
Jagraon	9
Jaleswar	1
Jalgaon	1
Jamnagar	1
Jasdan	1
Jayapatna	1
Jaynagar - Ii	1
Jintur	2
Junagadh	1
Junagarh	2
Kaikalur	1
Kajuluru	4
Kakching	1
Kalavad	1
Kallur	3
Kalna - I	8
Kalwan	8
Kanaganapalle	1
Kannad	5
Kapileswarapuram	3
Karapa	5
Karnal	5
Kavali	1
Kavathemahankal	4
Khacharod	2
Khajipet	1
Khambhalia	2
Khandaghosh	1
Khanna	2
Khategaon	4
Khedbrahma	1
Kheralu	1
Kichha	2
Kirlampudi	3
Korukonda	1
Kosigi	7
Kothapalle	3
Kuttanad	3
Latur	1
Limbdi	1
Mahesana	1
Malhargarh	1
Malout	2
Mamidikuduru	2
Manawar	3
Mandapeta	2
Mandsaur	2
Mansa	6
Manteswar	1
Mantha	1
Martur	1
Mauda	2
Mehkar	1
Memari - I	1
Moga	2
Mohol	1
Mopidevi	1
Muktainagar	1
Nadendla	2
Nagaram	1
Naidupet	3
Nandigama	6
Nandurbar	1
Narasaraopet	3
Nashik	6
Nilokheri	7
Niphad	2
Okhamandal	2
P.Gannavaram	2
Paithan	1
Palam	1
Pamarru	4
Panipat	5
Parola	1
Partur	1
Patti	3
Pedana	2
Pedaparupudi	3
Pedapudi	1
Pedda Thippasamudram	1
Pehowa	2
Penuganchiprolu	4
Pipariya	2
Pithapuram	2
Ponnur	1
Punganur	1
Raina - Ii	1
Rajanagaram	1
Rajkot	1
Rampur	1
Rampura Phul	3
Ranpur	1
Ratlam	8
Rayavaram	3
Razole	1
Rentachintala	1
S.Mydukur	1
Saharanpur	1
Samalkota	3
Sangamner	1
Sangrur	1
Sankhavaram	1
Sardulgarh	3
Sawer	1
Seethanagaram	1
Sehore	2
Shahade	1
Shahbad	5
Shirpur	1
Shivpuri	7
Sillod	1
Sirsa	7
Sonipat	19
Srinivaspur	1
Talala	1
Tenali	3
Thanesar	2
Thiruvallur	1
Tiruvuru	2
Upleta	1
Uppalaguptam	1
Vadali	1
Vaijapur	1
Vanthali	2
Vatsavai	1
Veldurthi	3
Venkatagirikota	6
Vijapur	1
Vijayawada (Rural)	2
Wadhwan	1
Warud	1
Washim	3
Yemmiganur	8
Zira	5
Grand Total	503

Re: Incorrect counts

prieper — Fri, 07 Sep 2018 10:13:43 GMT

put in the field "Marketing Territory" and you will get the count as above?

Re: Incorrect counts

bhuprakash — Fri, 07 Sep 2018 10:21:45 GMT

Hi Peter,

Not able to do so. Can you please do it for me in the attached file ??

Re: Incorrect counts

prieper — Fri, 07 Sep 2018 10:35:14 GMT

Just change the content of the pivot ...

You asked for something, but in the pivot you calculated on a different dimension...

Peter

Re: Incorrect counts

bhuprakash — Fri, 07 Sep 2018 11:03:38 GMT

Thanks Peter.

But If I am adding Sales Territory with this data then counts are just getting repeated.

Kindly check this.

Re: Incorrect counts

prieper — Fri, 07 Sep 2018 12:44:31 GMT

Dear,

the formula is correct, but think that there are some odd relations in your datamodel.

Suggest to solve the problem first in Excel and see what is inside.