Problem with Column Total

[#1]

I'm not allowed to do total in Pivot Table (box is desactivated); can someone help me please?

Show image attached!

[swuehl]

Are CA and GP expression labels or dimensions?

Partial sums are only available for dimensions level (but in fact, the totals are calculated by your expressions, of course).

[er_mohit]

if CA and GP is your dimension then

see the attached image

here ,uncheck the partial sum because mat_id is my dimension and see the pivot table there is no mentioning the total of that field

[#4]

Yes, CA and GP are expression, so which function I have to use in this level?

[swuehl]

Just enable partial sum for the dimensional level you want, e.g for the first dimension if you just want a grand total or for the other dimension levels if you want subtotals, too.

Maybe I just get what you want or what your exact issue is, could you upload a small sample qvw file that demonstrate your issue?

[#6]

Sorry for .qvw it's confidential, but you can see print screen below, I'm not able to check partial sum box's,maybe it's desactivated because CA is an calculated column?

[#7]

Hi, I find the source of this issue, please see below(pic1):

These zero not read like number in Qlikview! How can I convert knowing that I used this case(pic2) to convert "-" in"0"

Symbole"Nul" & Symbole "Manquant"

[swuehl · Accepted solution]

Sorry, I probably don't get what you want.

Don't try to set partial sums (sommes partielles) for an expression, check the box for any or all dimensions (e.g. P.R. is a dimensio, right? Select P.R. and check the partial sums checkbox to get a total line).

As I tried to explain in my previous post, you don't need to send confidential data. But if you want to help us to help you, try creating a small sample QlikView application (.qvw file) that demonstrate your issue. Could just contain some mockup data, but if you use a chart with one dimension and several expressions in your original application, try reproducing this layout also in your sample app.

Most of the time, while you are preparing a sample that focuses on your issue, you might already understand what your problem causes.