Cannot make work a Set Expression

cristian_av — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Cannot make work a Set Expression

sunny_talwar — Thu, 05 Jan 2017 13:44:32 GMT

May be this:

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

topic Cannot make work a Set Expression in QlikView

Cannot make work a Set Expression

Re: Cannot make work a Set Expression