topic Re: Problem with Column Total in QlikView

Problem with Column Total

Fri, 15 Feb 2013 11:06:56 GMT

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

Show image attached!

Re: Problem with Column Total

swuehl — Fri, 15 Feb 2013 11:24:50 GMT

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).

Re: Problem with Column Total

er_mohit — Fri, 15 Feb 2013 11:58:58 GMT

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

Re: Problem with Column Total

Fri, 15 Feb 2013 15:21:16 GMT

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

Re: Problem with Column Total

swuehl — Fri, 15 Feb 2013 15:25:09 GMT

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?

Re: Problem with Column Total

Fri, 15 Feb 2013 16:04:52 GMT

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?

Re: Problem with Column Total

Fri, 15 Feb 2013 16:25:31 GMT

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"

Re: Problem with Column Total

swuehl — Fri, 15 Feb 2013 16:26:49 GMT

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.