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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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


Labels (1)
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP

May be this:

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

View solution in original post

1 Reply
sunny_talwar
MVP
MVP

May be this:

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