Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
josephinetedesc
Creator III
Creator III

how to: set analysis or if statement

LocalityNorthNorthSouthSouthEastEastWestWestSESETOTALTotal
Month-YrJun 2015Jun 2014Jun 2015Jun 2014Jun 2015Jun 2014Jun 2015Jun 2014Jun 2015Jun 2014Jun 2015Jun 2014
Cars sold686273722091911281556056538536
Cars Paid617060622041831331566743525514
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

23 Replies
Not applicable

Hi,

You need to select dimension and then select partial sum

.

Capture.PNG

josephinetedesc
Creator III
Creator III
Author

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

PrashantSangle

Hi,

Drag your dimension to top.

You will get desired output.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
josephinetedesc
Creator III
Creator III
Author

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!

josephinetedesc
Creator III
Creator III
Author

the other thing is that in the example above 'Cars sold" is a dimension not a calculated dimension

josephinetedesc
Creator III
Creator III
Author

so maybe the data is more like this:

ActivityvalueDateLocality
Cars sold681/05/2015North
Cars Paid612/05/2015North
Cars sold733/05/2015South
Cars Paid604/05/2015South
Cars sold2095/05/2015East
Cars Paid2046/05/2015East
Cars sold1287/05/2015West
Cars Paid1338/05/2015West
Cars sold609/05/2015SE
Cars Paid6710/05/2015SE

Wonder if I need to change my data model!

josephinetedesc
Creator III
Creator III
Author

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


Capture.PNG

josephinetedesc
Creator III
Creator III
Author

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

qlikviewwizard
Master II
Master II

Hi josephinetedesco,

Did you resolve your issue?

josephinetedesc
Creator III
Creator III
Author

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