This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
Hey guys. I have a ton of transactional credit card data. I need to determine the Date on which a given Employee/Vendor combination achieved $5000 in charges using the load script.
For example, if Jeff charges $1000 to Microsoft on the first day of every month starting on January 1st, I'd want to know that he totaled $5000 with Microsoft on May 1st.
Any wisdom on this would be very much appreciated.
would you be able to share sample data with expected output?
Thanks for the reply! Ultimately, the 5K_Flag column in this example is what I want to produce. It is a flag that tells me that an Employee has reached $5K with a Vendor for the year, and flags every transaction after that point.
"Running Employee/Vendor Total"
(html, utf8, embedded labels, table is @1);
if(Running_Total>=5000,1,0) as [5K_Flag];
if(Peek(Employee)=Employee, RangeSum(Peek(Running_Total),Amount),Amount) as Running_Total
Order by Employee,"Date";
Drop Table Data;