topic Using Range values in set analysis in QlikView

Using Range values in set analysis

Jsbecker — Sat, 16 Nov 2024 19:49:11 GMT

Hello Community, I need help with this set analysis.

I need to get values between two different times.

I put it in a set analysis without any lucky.

Can you help me, please?

HorarioJugada = {">= TIME(TIME('11:15','hh:mm') - ($(vMinutosAntesCierre)/(24*60)),'hh:mm') <= TIME('11:15','hh:mm')"}

Thanks a lot

sunny_talwar — Thu, 24 Oct 2019 14:43:56 GMT

May be this

HorarioJugada = {">=$(=Time(MakeTime(11, 15)-($(vMinutosAntesCierre)/(24*60)), 'hh:mm'))<=$(=Time(MakeTime(11, 15), 'hh:mm'))"}

Jsbecker — Fri, 25 Oct 2019 15:21:08 GMT

It works! Thank you very much.