Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
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

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) )