Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

It is possible to put a subtotal inside a dimension?

Dear all,

I haven't posted anything in a while, now I'm seeing this new forum design... is great!!!

Now, to what matters:

In the attached file, you can see that I have already designed a Pivot Table with results of certain indicators in several categories. But as a requirement from my employeers, I need to put a subtotal row only for certain categories that should not affect the total result. Is there any way to accomplish this?

I guess my question should be better understood seing the attached file.

As usual, thanks for any comments.

1 Solution

Accepted Solutions
Not applicable
Author

Could you try this?

In Qlikview Load script, add in one more column 'Sub Category',

if Your category is 'A' or 'B', you put one value.

If it is rest, you put another?

in your pivot, you use the 'Sub Category' as one more dimension.

View solution in original post

10 Replies
Not applicable
Author

Hi,

You can have a Calculated Dimension where you can use Aggr() function with your constraints.

Regards,

Amit

Not applicable
Author

Hi Amit,

Thanks for your answer, but I'm not certain on how can I use a Calculated Dimension to perform this, could you please explain this further?

Regards,

Andrés Jején

Not applicable
Author

Dear All,

I've been following this for a while, but no replies whatsoever... Pls anyone can help me? I'm a bit desperated with this...

Regards

Not applicable
Author

Could you try this?

In Qlikview Load script, add in one more column 'Sub Category',

if Your category is 'A' or 'B', you put one value.

If it is rest, you put another?

in your pivot, you use the 'Sub Category' as one more dimension.

Not applicable
Author

Hi,

for all I know, the only solution is to use a paramount dimension as it´s descriped by mingming before.


I´ve had already a lot of requirements like this, but i never found a satisfying solution. Also the qlikview-support propose to use a paramount dimension.

Greets

Not applicable
Author

Thanks to everyone for your answers... indeed, I had to use the paramount dimension, here's the result:

Regards!

Not applicable
Author

Andres, try to explain, because I do not speak English. could put a sample script used

thanks

bgarland
Creator III
Creator III

Why can't you just use the Partial Sums option in the pivot's properties?

Not applicable
Author

What I need to do is the following: The total "D" is not the sum of all rows but corresponds to SUMPRODUCT (C2: C9, D2: D9) / SUM (D2: D9), and the totals for "A", "B" and "C" correspond to the sum of their ranks.

Dia

A

B

C

D

01-nov

3.711

3.312

2.260

312

02-nov

9.413

8.966

5.672

320

03-nov

9.399

8.385

4.353

342

04-nov

8.718

8.420

6.827

330

05-nov

8.572

7.775

5.737

324

06-nov

7.309

7.069

5.575

327

07-nov

4.709

4.366

3.531

310

08-nov

3.141

3.103

2.882

307

Total

54.972

51.396

36.837

325