Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
cristian_av
Creator III
Creator III

Cannot make work a Set Expression

I

I'm trying to create a expression to Sum "VolumenReal" with the field PeriodoNumVol having the selection equal to all possible values of the field PeriodoNum.

PeriodoNum and PeriodoNumVol has date values (Year-Month) as this:

201601

201602

201603

201604


My expression (not working) is this:

=Sum(  {$<PeriodoNumVol = {">$(=Min(PeriodoNum))<$(=Max(PeriodoNum))"}>}   VolumenReal )


Can anybody help me please?

Thanks!

borrar.png


1 Solution

Accepted Solutions
sunny_talwar

May be this:

=Sum( {$<PeriodoNumVol = {">$(=Date(Min(PeriodoNum), 'YYYYMM'))<$(=Date(Max(PeriodoNum), 'YYYYMM'))"}>} VolumenReal)

View solution in original post

1 Reply
sunny_talwar

May be this:

=Sum( {$<PeriodoNumVol = {">$(=Date(Min(PeriodoNum), 'YYYYMM'))<$(=Date(Max(PeriodoNum), 'YYYYMM'))"}>} VolumenReal)