Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
becki_kain
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
atkinsow
Valued Contributor II

Re: table of totals?

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

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

;


Table2:

Load *,

1+1 as NewField

Resident Table1;


Drop table Table1;

31 Replies
Khan_Mohammed
Honored Contributor II

Re: table of totals?

add all the expressions?

becki_kain
New Contributor III

Re: table of totals?

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

Khan_Mohammed
Honored Contributor II

Re: table of totals?

Untitled.png

Aren't the totals in the bottom?

Can you explain clearly what you looking for?

atkinsow
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?

becki_kain
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

becki_kain
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

atkinsow
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

becki_kain
New Contributor III

Re: table of totals?

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

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