topic Problem with pivot table in QlikView

Problem with pivot table

Tue, 02 Jun 2009 18:53:20 GMT

i am facing a weird problem while showing 2 months data in pivot table. pls check attached report for the same. I need to use SUM(HEADCOUNT) for expression formulae. if i show month,employee wise data in excel, total headcount is 4 [2 for each month]. But qlikview says 8.

Pls help me out. this is highly urgent

Problem with pivot table

Tue, 02 Jun 2009 19:42:14 GMT

Hi,

for some reason every month in your ZCOPMONTH field is known four times by QlikView.

Sum(Distinct HEADCOUNT) is the right expression for a quick solution. Using a straight table will give you the right numbers.

Next step should be to find out why you have every month four times in your table.

Rainer

Problem with pivot table

sathishkumar_go — Tue, 02 Jun 2009 19:43:03 GMT

Hi Please find the attachements.... use distinct -Sathish