Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ysiroong
Contributor III
Contributor III
‎2010-08-10 04:22 PM

Sum(Total) With 2 Dimensions

<body><p>Below is the table that I need to produce.  The DistrictAmt column is totaled by the DisManager dimension.  The DivisionAmt column is total by the DivManager.  The CompanyAmt column is totaled by the entire data set. </p> <p> </p> <p>Does anyone know how this can be done?  To get the CompanyAmt I used Sum(Total &lt;Cat&gt; StoreAmt) and that worked, but I can't figure out how to do the calculation at the district or division level. </p> <p> </p> <p><col width="83"></col><col width="82"></col><col width="41"></col><col width="58"></col><col width="66"></col><col width="75"></col><col width="82"></col><col width="93"></col> <tr height="17"> <td height="17" width="83"><a href="https://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/3731.untitled.PNG"><img src="/resized-image.ashx/__size/550x0/__key/CommunityServer.Discussions.Components.Files/11/3731.untitled.PNG" border="0" /></a><br /></td> <td width="82"><br /></td> <td width="41"><br /></td> <td width="58"><br /></td> <td width="66"><br /></td> <td width="75"><br /></td> <td width="82"><br /></td> <td width="93"><br /></td> </tr> </p> <p> </p> <p> </p> <p> </p> <p> </p></body>

2,773 Views
0 Likes
1 Solution

Accepted Solutions
johnw
Champion III
Champion III
‎2010-08-10 04:31 PM

I believe this?

sum(total <DisManager, Cat> StoreAmt)
sum(total <DivManager, Cat> StoreAmt)
sum(total <Cat> StoreAmt)

View solution in original post

2,009 Views
4 Replies
johnw
Champion III
Champion III
‎2010-08-10 04:31 PM

I believe this?

sum(total <DisManager, Cat> StoreAmt)
sum(total <DivManager, Cat> StoreAmt)
sum(total <Cat> StoreAmt)

2,010 Views
ysiroong
Contributor III
Contributor III
‎2010-08-10 04:52 PM
Author

In response to johnw

I see. I couldn't figure out how the format. I was trying <DisManager><Cat> and variants of that nature.

Is there a reference guide that shows how to use this? I didn't see this type of example in the help section of the QlikView application.

I assume you can only reference dimensions that are in the table? For instance, I can't just have a table with "Store, Cat, StoreAmt, DistrictAmt, DivisionAmt, CompanyAmt" and use this same calculation?

2,009 Views
0 Likes
johnw
Champion III
Champion III
‎2010-08-10 04:58 PM

In response to ysiroong

The reference guide should be in the Documentation directory wherever you installed QlikView. And it's probably somewhere in the help text, but I'm not sure what I'd search for, so it isn't surprising that you couldn't find it.

I can't remember if you can use dimensions that aren't in your table. I'm guessing you can. Give it a shot and see what happens. 🙂

2,009 Views
0 Likes
ysiroong
Contributor III
Contributor III
‎2010-08-10 05:00 PM
Author

In response to johnw

I tried and the the columns just all summed up to the "company" level.

Oh well, Thanks for solving the issue though!

2,009 Views
0 Likes