Slowly getting to grips with Qlikview and it seems that a lot of the 'manipulations' are done within the loading script or expressions. I wonder if there is another way to go about doing subtotals / groups.
I have a dimension called "Result" and I want to show all the values of "Result" but I also want to show subtotals within the variable.
For example, the results might be..(please excuse the footballing example!)
Result Count of Result
Goal 4
Offside 6
Penalty 2
Foul 12
Throw in 9
Corner 7
But in my table (and probably a chart as well) I would like to show "Free Kicks" as the sum of Offside, Penalty and Foul and "Restart" as the sum of Throws and corner, plus a total for all results
Goal 4
Offside 6
Penalty 2
Foul 12
Free Kick 20
Throw in 9
Corner 7
Restart 16
All results 40
Any advice on this and also any pointers on where to look for very basic guides to expressions, sorting, grouping etc would be very gratefully received
P Think green - please do not print this email unless you really need to
This email, and all related attachments, is strictly confidential and intended solely for the person or organisation to whom it is addressed. If you have received this information in error, please notify us as soon as possible and delete the email. If you are not the intended recipient, you must not copy, distribute or take any action in reference to it. Any such action may be unlawful.
Jelf Insurance Brokers Ltd* (Reg No. 0837227), Jelf Wellbeing Ltd* (Reg No. 2647586), Jelf Financial Planning Ltd* (Reg No. 3072281) and Jelf Commercial Finance Ltd (Reg No. 4333281) are part of Jelf Group plc (Reg No. 2975376) and are all registered in England and Wales at Hillside Court, Bowling Hill, Chipping Sodbury, BS37 6JX. *Authorised and regulated by the Financial Conduct Authority (FCA). Not all products and services offered are regulated by the FCA.
