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

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: 
Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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: 
Not applicable
‎2010-03-07 10:32 PM

Date Ranges and Order totalling question

<body><p>Hi,</p> <p>I've been messing about with set analysis and conditional SUM operations [e.g. SUM(field1 * if(someBoolFunction, 1, 0))] to try to create the results below. I've copied the table to start with, then 6 possible selections of Begin and End date fields I have tied to calendar controls. I've copied the desired results for each order per selection on the right. I just can't seem to get there!</p> <p>Any comments greatly appreciated!</p> <p> </p> <p><col width="101"></col> <col width="80"></col> <col width="138"></col> <col width="86"></col> <col width="64"></col> <tr height="20"> <td width="101" height="20">Order Number</td> <td width="80">Operation</td> <td width="138">Total Order Amount</td> <td width="86">Date</td> <td width="64"></td> </tr> <tr height="20"> <td align="right" height="20">123</td> <td>Created</td> <td align="right">1000</td> <td align="right" class="xl63">1/02/2010</td> <td></td> </tr> <tr height="20"> <td align="right" height="20">123</td> <td>Changed</td> <td align="right">1500</td> <td align="right" class="xl63">2/02/2010</td> <td></td> </tr> <tr height="20"> <td align="right" height="20">123</td> <td>Changed</td> <td align="right">1600</td> <td align="right" class="xl63">3/02/2010</td> <td></td> </tr> <tr height="20"> <td align="right" height="20">456</td> <td>Created</td> <td align="right">500</td> <td align="right" class="xl63">4/02/2010</td> <td></td> </tr> <tr height="20"> <td align="right" height="20">456</td> <td>Changed</td> <td align="right">400</td> <td align="right" class="xl63">5/02/2010</td> <td></td> </tr> <tr height="20"> <td align="right" height="20">456</td> <td>Changed</td> <td align="right">300</td> <td align="right" class="xl63">6/02/2010</td> <td></td> </tr> <tr height="20"> <td height="20"></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr height="20"> <td height="20"></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr height="20"> <td height="20">Begin Range</td> <td>End Range</td> <td></td> <td class="xl63"></td> <td></td> </tr> <tr height="20"> <td align="right" class="xl63" height="20">1/02/2010</td> <td align="right" class="xl63">6/02/2010</td> <td></td> <td align="right">123</td> <td align="right">1600</td> </tr> <tr height="20"> <td height="20"></td> <td></td> <td></td> <td align="right">456</td> <td align="right">300</td> </tr> <tr height="20"> <td height="20"></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr height="20"> <td align="right" class="xl63" height="20">2/02/2010</td> <td align="right" class="xl63">6/02/2010</td> <td></td> <td align="right">123</td> <td align="right">600</td> </tr> <tr height="20"> <td height="20"></td> <td></td> <td></td> <td align="right">456</td> <td align="right">300</td> </tr> <tr height="20"> <td height="20"></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr height="20"> <td align="right" class="xl63" height="20">3/02/2010</td> <td align="right" class="xl63">6/02/2010</td> <td></td> <td align="right">123</td> <td align="right">100</td> </tr> <tr height="20"> <td height="20"></td> <td></td> <td></td> <td align="right">456</td> <td align="right">300</td> </tr> <tr height="20"> <td height="20"></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr height="20"> <td align="right" class="xl63" height="20">4/02/2010</td> <td align="right" class="xl63">6/02/2010</td> <td></td> <td align="right">123</td> <td align="right">0</td> </tr> <tr height="20"> <td height="20"></td> <td></td> <td></td> <td align="right">456</td> <td align="right">300</td> </tr> <tr height="20"> <td height="20"></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr height="20"> <td align="right" class="xl63" height="20">5/02/2010</td> <td align="right" class="xl63">6/02/2010</td> <td></td> <td align="right">123</td> <td align="right">0</td> </tr> <tr height="20"> <td height="20"></td> <td></td> <td></td> <td align="right">456</td> <td align="right">-100</td> </tr> <tr height="20"> <td height="20"></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr height="20"> <td align="right" class="xl63" height="20">6/02/2010</td> <td align="right" class="xl63">6/02/2010</td> <td></td> <td align="right">123</td> <td align="right">0</td> </tr> <tr height="20"> <td height="20"></td> <td></td> <td></td> <td align="right">456</td> <td align="right">-100</td> </tr> </p></body>

267 Views
0 Likes
1 Reply
Not applicable
‎2010-03-07 10:34 PM
Author

OK... the table pasted fine in the text editor but came out terrible on the web page. Hopefully this excel link works with the data.

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/4628.Book1.xlsx:550:0]

191 Views
0 Likes