topic Re: Re: Subtotals or groups in QlikView

Subtotals or groups

Anonymous — Wed, 01 Oct 2014 10:16:27 GMT

Hi all.

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

Many thanks

Re: Subtotals or groups

sorrakis01 — Wed, 01 Oct 2014 10:22:35 GMT

Hi,

An easy movement for your example is create a variable or a field in the script with the sum of the 3 fields.

Regards

Re: Subtotals or groups

Anonymous — Wed, 01 Oct 2014 10:33:47 GMT

Thank you for your reply but I am very new to Qlikview so I am not sure what that means!!

Re: Subtotals or groups

Michiel_QV_Fan — Wed, 01 Oct 2014 10:40:56 GMT

Re: Subtotals or groups

raghavsurya — Wed, 01 Oct 2014 10:47:00 GMT

Hi Paul,

Alternatively you can use Pivot table which enable you to generate partial sums. You will have to create one mapping column to link

Goal 4

Offside 6

Penalty 2

Foul 12

with Free Kick and other two with restart. You can enable show partial sum at the column in Presentation tab to get the desired result.

Re: Subtotals or groups

Anonymous — Wed, 01 Oct 2014 10:50:52 GMT

I am using real and sensitive data so sadly i cant upload

Re: Subtotals or groups

sorrakis01 — Wed, 01 Oct 2014 10:52:33 GMT

Hi,

The solutions of our partners are right. Try this.

Regards,

Re: Subtotals or groups

Anonymous — Wed, 01 Oct 2014 11:05:54 GMT

This seems like what I am looking for! Although how do I add a mapping column?

On another note, is there anywhere I can find examples of full scripts which include the load and other functions such as Groups, Cross Table (and any other popular tasks I suppose)

Re: Subtotals or groups

sorrakis01 — Wed, 01 Oct 2014 11:42:10 GMT

Hi Paul,

Look this http://community.qlik.com/docs/DOC-5791

Re: Re: Subtotals or groups

sorrakis01 — Wed, 01 Oct 2014 11:53:02 GMT

Hi again,

Try this.

Regards.

Re: Subtotals or groups

sorrakis01 — Wed, 01 Oct 2014 15:13:15 GMT

Hi Paul,

It works?

Re: Subtotals or groups

Anonymous — Wed, 01 Oct 2014 15:16:04 GMT

Hi Jordi

Still trying to get my head around it! Have a less busy day tomorrow so more time to practice!

Paul Lazard

Data Analyst

Jelf

Tel: 01454 525002 Mob: 07894 395105

Insurance <http://www.jelfgroup.com/page/business-services/insurance> | Employee Benefits <http://www.jelfgroup.com/page/business-services/employee-benefits> | Financial Planning <http://www.jelfgroup.com/page/individual-services/financial-planning>

Jelf

Hillside Court, Bowling Hill, Chipping Sodbury, BS37 6JX Tel: 01454 272727 Fax: 01454 272728

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.