# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for
Did you mean:
Highlighted
Contributor III

## Help with condition

Hy everyone!

I'm stuck with this situation/condition

Suppose I have this simple table ordered by date, with day and q as a quantity of something. I need to build an accumulator that accumulates Q only within the same day. So day 1-1-2018 ends with 4 and day 2-1-2018 ends with 6

DayQConditional Acumulator
2-1-201811
2-1-201834
2-1-201804
2-1-201826
1-1-201833
1-1-201814

I build this sentence but is missing the last row of each day...

If(Date(day-1) = Previous(day), Acum+q) as acum,

Can anyone have a clue of how to get this done the way I need?

Christian

5 Replies
Highlighted
Specialist II

Are you looking for sum of quantity by day? Not sure what you mean by accumulator.

Can you add the expected output.

Thanks

Highlighted
Specialist

Hi,

DATA:
Q,
[Conditional Acumulator]
FROM
[..\..\descargas\ENERO.xlsx]
(
ooxml, embedded labels, table is Sheet2);

Highlighted
Creator

I would say try some set analysis that works with Sum(q) like SUM({<Day = {Day}>}Q)

That may not be correct but doesn't hurt to try and is fast.

Highlighted
Contributor III