subtotals needed? pivot or line chart?

[becki_kain]

i need to do subtotals for car segments in a rows called "car".  i tried doing this:

Segments:

LOAD * INLINE

[ Segment, SortOrder

Small B Car, 1

Small C Car, 2

Medium Car, 3

Large Car, 4

Sports, 5

Small B/C Premium, 6

Medium Premium, 7

Large Premium, 8

F/Sports Premium, 9

Car, 10

where all of the above are actually listed in a table, under the heading Segment, except the word Car.   I did the inline load to keep the order, in the final table, of what I needed, but how do i get a subtotal of all car segments, in the row labeled "car"?  thanks

becki kain

[felipedl]

Hi Becki,

Couldn't quite figure out what you need, could you explain a little more?

Probably some sample data or QVW would help.

Felipe.

[florentina_doga · Accepted solution]

pls see attach

[becki_kain]

yes, that seems to be exactly what I need.  i'm jumping ahead, before reading the qlikview for developers book, in porting some complex excel first to alteryx, then to qlik.  this looks like what I need .  thank you

-becki kain