Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Locality | North | North | South | South | East | East | West | West | SE | SE | TOTAL | Total |
Month-Yr | Jun 2015 | Jun 2014 | Jun 2015 | Jun 2014 | Jun 2015 | Jun 2014 | Jun 2015 | Jun 2014 | Jun 2015 | Jun 2014 | Jun 2015 | Jun 2014 |
Cars sold | 68 | 62 | 73 | 72 | 209 | 191 | 128 | 155 | 60 | 56 | 538 | 536 |
Cars Paid | 61 | 70 | 60 | 62 | 204 | 183 | 133 | 156 | 67 | 43 | 525 | 514 |
if(location = 'North',(sum(Cars sold)) | ||||||||||||
or | ||||||||||||
if(location = 'South',(sum(Cars sold)) | ||||||||||||
or | ||||||||||||
if(location = 'East',(sum(Cars sold)) | ||||||||||||
or | ||||||||||||
sum({$}(Cars sold)) | ||||||||||||
))))) |
I have a pivot table and Locality is a dimenstion -so how do I get the total in this case? Even using the set analysis - i do not have a column for the Total - so i need to load a 'dummy' Locality?
Thank you
Jo
Hi,
You need to select dimension and then select partial sum
.
Hi Jemimah but ... I want Cars Sold and Cars paid on the LHS and Localilty and Month on the top. Are you using a pivot table?
Jo
Hi,
Drag your dimension to top.
You will get desired output.
Regards
uh huh!!!! so the problem is that QlikView is not reading my expression as a number I think .... cos certainly using the qvw supplied it works, when I try my figures in QlikView ... it does not show "show partial sums" - Will epxeriment!
the other thing is that in the example above 'Cars sold" is a dimension not a calculated dimension
so maybe the data is more like this:
Activity | value | Date | Locality |
Cars sold | 68 | 1/05/2015 | North |
Cars Paid | 61 | 2/05/2015 | North |
Cars sold | 73 | 3/05/2015 | South |
Cars Paid | 60 | 4/05/2015 | South |
Cars sold | 209 | 5/05/2015 | East |
Cars Paid | 204 | 6/05/2015 | East |
Cars sold | 128 | 7/05/2015 | West |
Cars Paid | 133 | 8/05/2015 | West |
Cars sold | 60 | 9/05/2015 | SE |
Cars Paid | 67 | 10/05/2015 | SE |
Wonder if I need to change my data model!
How do I upload the app? In any case I have discovered the Aggr function. However still not able to get the total of all Localities on the horizontal ... ie the Total of East, North, South, West
Row and Column totals in pivot table
//community.qlik.com/message/716385#716385
I cannot open the QlikView document tonight, but i will try this tomorrow morning. The discussion was:
In a pivot table, I would like to show some dimensions totals in rows and some in columns.
I have searched this community and one advice is to use Subtotals on Top/Bottom. but this is making no difference; all totals appear at the bottom or top of columns, but never at the end of rows.
This was unanswered and posted in February
Hi josephinetedesco,
Did you resolve your issue?
Hi Wizard
no - not yet, although I did download the app from
//community.qlik.com/message/716385#716385
and it is what I wanted.
For the moment I have a chart with a dimension called locality and monthname and then next to it I have a cloned chart with the locality removed. This off course gave me another problem ... how do you "FIX" charts and tables so that they do not move - however it will have to do for the moment.
Jo