Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

scotly-victor
Contributor

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
Honored Contributor III

Re: cumulative with Max of Date

Hi Scotly,

Table

Dimensions :

=Aggr(MaxString(Date),store)

store

Expression

Sum(amount)

Regards,

Antonio

md_qlikview
Contributor II

Re: cumulative with Max of Date

Hi Scotly,

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

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

Community Browser