# New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
New Contributor III

## table of totals?

i have a pivot table, as shown below, and i broke up the very complex equations to individual columns then put them together, as shown below.  I had to do this as a pivot table to get the subtotals (the column where "Car" will have "utility" and "truck" later on).  the problem is with the pivot table, i can't hide the pieces of the equations so the final columns will be these massive and unweildy equations.  if i break up the charts into line charts of "car" "utility" and "truck, i can get the subtotals of each but how do i add those subtotals to get the final line of totals (and the bottom of this chart)?  thanks

becki kain

Tags (1)
1 Solution

Accepted Solutions
Valued Contributor II

## Re: table of totals?

You would have to do a resident load off of the inline.

Table1:
Dept, Project, Amount
IT, Hardware, 10000.00
IT, SOFTWARE, 3000.00
CIVIL, Furniture, 100000.00
CIVIL, BUILDING AT NEW LOCATION, 5000000.0
]

;

Table2:

1+1 as NewField

Resident Table1;

Drop table Table1;

31 Replies
Honored Contributor II

## Re: table of totals?

New Contributor III

## Re: table of totals?

I need the totals running across the bottom row, not as an expression. thanks

Honored Contributor II

## Re: table of totals?

Aren't the totals in the bottom?

Can you explain clearly what you looking for?

Valued Contributor II

## Re: table of totals?

I'm not exactly sure what you're trying to do.  Can you mock up what you want it to look like?

New Contributor III

## Re: table of totals?

I want, in alteryx, to break up the data, by vehicle type, then make a line chart for each, not pivot chart, so I can hide all the extra expressions but then add up all the "total" lines, at the bottom, like it's done in the picture  you showed

or, how do you do subtotals without doing a pivot table?  thanks

New Contributor III

## Re: table of totals?

 Industry (%) Small B Car 3.0 Small C Car 13.2 Medium Car 9.8 Large Car 1.4 Sports 1.3 Small B/C Premium 0.6 Medium Premium 2.8 Large Premium 1.2 F/Sports Premium 0.6 CAR 34.2

then the truck one, then the utility one, then a row of totals from all 3 charts

Valued Contributor II

## Re: table of totals?

Try this attachment.

If that still isn't what you're looking for try:

Is there a way to show partial totals in straig... | Qlik Community

New Contributor III

## Re: table of totals?

that's still a pivot table so I can't hide expressions.  thanks

Valued Contributor II

## Re: table of totals?

What are you trying to hide?  The way I changed it, each column is independent.  So you would just remove the columns you don't want to see.