topic Re: Calculation within pivot table in QlikView

Calculation within pivot table

Tue, 04 Feb 2014 11:37:08 GMT

Hi all.

I have a pivot table with to calculations that doesen't give me the right value.I have the right values for every row when the table is collapsed but when the table is expand the "row valuesl" is wrong. Se example below:

Expression for num of events:

count({$<EventCode={'516','521','524','525','526','527'}>} EventCode)

I guess it should be something like this expression but it doesn't work:

sum(aggr(count({$<EventCode={'516','521','524','525','526','527'}>} EventCode), CostCenter))

Suggestions to solve this?

Re: Calculation within pivot table

Gysbert_Wassenaar — Tue, 04 Feb 2014 12:33:30 GMT

I don't see anything wrong at first glance. I cannot reproduce this. Can you post an example document that demonstrates the problem?

Re: Calculation within pivot table

senpradip007 — Tue, 04 Feb 2014 12:39:47 GMT

Hi.

What's your problem? Can you elaborate on this issue?

Re: Calculation within pivot table

Tue, 04 Feb 2014 14:15:37 GMT

If you look at the two tables above you can see that the firts table that is collapse the totals for each month is correct but when I expand the table, like the second table, you can see that it is wrong values.

Re: Calculation within pivot table

tmumaw — Tue, 04 Feb 2014 14:20:52 GMT

Did you try count({$<EventCode={'516','521','524','525','526','527'}>} Distinct EventCode)

Re: Calculation within pivot table

Tue, 04 Feb 2014 14:56:07 GMT

Yes, it does not solve the problem.