Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
mahinkle
New Contributor III

Re: Subtotals by data values in fields - straight and pivot table

that sure is on the right track!!    I would like the word total to be a seperate line in color field, and not sure I understand why there are 2 cost columns.     in my original post I have a picture of what they are looking for (you know can you take this excel spreadsheet and put it in QV but make it look like this....)  Your definately on the right track

Re: Subtotals by data values in fields - straight and pivot table

Two cost columns because subtotals for each would show only if I have more than 1 dimension here. So I added Cost as another dimension. Let me see if I can fix the color thingie.

Best,

Sunny

Re: Subtotals by data values in fields - straight and pivot table

See if this is helpful (PFA)

Best,

Sunny

View solution in original post

mahinkle
New Contributor III

Re: Subtotals by data values in fields - straight and pivot table

yes yes thats what I need (well I dont need the first column but surely I can hide that (1,2,3)    Totally cool  do you have an explanation of how you did this?

mahinkle
New Contributor III

Re: Subtotals by data values in fields - straight and pivot table

im assumming i can put a grand total in there also...

Re: Subtotals by data values in fields - straight and pivot table

I just created the groupings in the script and then used partial totals for color within each Group. You can creat the subtotal by adding a partial subtotal for Group.

HTH

Best,

Sunny

mahinkle
New Contributor III

Re: Subtotals by data values in fields - straight and pivot table

THANK YOU so much!

Re: Subtotals by data values in fields - straight and pivot table

Not a problem, I am glad I was able to help.

Best,

Sunny