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
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
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
‎2013-03-23 05:13 AM

I have data like attached below and i want accumulated Sale based on month during script load the what is the solution

Help me on this....

Book1.xlsx
397 Views
0 Likes
1 Reply
Not applicable
‎2013-03-23 05:58 AM
Author

Hi

use cross table and then in load statement use NumSum(as Shown below).

NumSum(Amount, peek(AccSum)) as AccSum.

330 Views
0 Likes