Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
scotly-victor
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
antoniotiman
Master III
Master III

Hi Scotly,

Table

Dimensions :

=Aggr(MaxString(Date),store)

store

Expression

Sum(amount)

Regards,

Antonio

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