topic Re: %'s in Pivot Table in QlikView

%'s in Pivot Table

wgonzalez — Thu, 24 Oct 2013 13:18:06 GMT

I'm using a pivot table to group costs by two dimensions.

Situation:

- When dimensions are expanded %'s are calculated correctly.

- When dimensions are contracted %'s are incorrect. QV is summing %'s instead of calculating them at total level.

Any idea of how can this be fixed?

This is the Expression calculation:

sum({<WO_State={'Closed'}>}[Cost of Scrap]/VOP)

As you can see, I'm using a Set Modifier.

Re: %'s in Pivot Table

Jason_Michaelides — Thu, 24 Oct 2013 13:21:40 GMT

Try:

sum({<WO_State={'Closed'}>}[Cost of Scrap]) / sum({<WO_State={'Closed'}>}VOP)

Hope this helps,

Jason

Re: %'s in Pivot Table

wgonzalez — Thu, 24 Oct 2013 13:25:08 GMT

Hi Jason,

I've alread tried that, but results are blank. No information at all.

Re: %'s in Pivot Table

Jason_Michaelides — Thu, 24 Oct 2013 13:27:24 GMT

Can you post a sample app?

Not sure this will give the right result, but try:

sum({<WO_State={'Closed'}>} TOTAL [Cost of Scrap]/VOP)

Re: %'s in Pivot Table

wgonzalez — Thu, 24 Oct 2013 14:16:11 GMT

Weird thing, this is what worked good:

[Cost of Scrap] / VOP

No set modifier, no SUM function. It's weird since I wanted to restrict the data set to those whos value in field "WO_State" is "Closed". The set modifier works fine for other calculations or fields in the same pivot. Only for %'s need to be taken out.

Any comments?

Re: %'s in Pivot Table

Jason_Michaelides — Thu, 24 Oct 2013 15:23:23 GMT

Can you post your app?