Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Alfovic
New Contributor

how to sum values from a date that also did have values for another date

Hi everyone,

i´d like to know if it is possible if you have a table with a column for :

  • dates
  • categories
  • values

could you sum the values as of an specific date and category where also those values for those categories also existed for another specific date?

for example: sum all values of categories "C" as of "01-05-2019" that existed by "01-04-2019"?

any help would be greatly appreciated!

Labels (3)
3 Replies
Channa
Valued Contributor III

Re: how to sum values from a date that also did have values for another date

=Aggr(Sum(Value),Category,Date)

Channa
Highlighted
Alfovic
New Contributor

Re: how to sum values from a date that also did have values for another date

Thanks Channa,
tried "sum(aggr(sum({<date= {"$(vMaxDate)"}>}value), category,date))"
but got the sum of the max date for all categories
Channa
Valued Contributor III

Re: how to sum values from a date that also did have values for another date

you can work with P()

it will help with Categories exist only max date

 

try the P() and E()

Channa