Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

cumulative with Max of Date

This is my data

Input

Date, store ,amount

1/6/2017,AAA,30

4/6/2017,AAA,40

19/6/2017,AAA,30

1/6/2017,BBB,30

4/6/2017,BBB,40

1/6/2017,CCC,20

4/6/2017,CCC,40

19/6/2017,CCC,30


Desired Output in front end

Date, store ,amount

19/6/2017,AAA,100

4/6/2017,BBB,70

19/6/2017,CCC,90



2 Replies
Highlighted
Master III
Master III

Hi Scotly,

Table

Dimensions :

=Aggr(MaxString(Date),store)

store

Expression

Sum(amount)

Regards,

Antonio

Highlighted
Creator II
Creator II

Hi Scotly,

PFA Qvw for your reference. You need to use set expression with aggr function like below.

Sum(Aggr( Sum(amount), store) )