topic Re: Filter between two Date in QlikView

Filter between two Date

danosoft — Tue, 26 Jun 2018 15:35:33 GMT

Hi i have this set analisys in a my straight table:

{<DATA_OUT={">$(=Date($(vFineMonthContrAlt), 'DD/MM/YYYY'))"},DATA_OUT={"<=$(=Date($(vFineMonthContrAltSCAD), 'DD/MM/YYYY'))"}>}

the value of my variable $(vFineMonthContrAlt) is the end of the month i choose (ex: 31/03/2018)

the value of my variable $(vFineMonthContrAltSCAD) is the end of the next month i choose (ex: 30/04/2018)

so with this set analisys i thought i can take record in the range :

DATA_OUT > 31/03/2018 and DATA_OUT <= 30/04/2018

but this is not......

i look it only consider the second filter DATA_OUT <= 30/04/2018 and not the first..... why?

thanks

Re: Filter between two Date

olivierrobin — Tue, 26 Jun 2018 15:40:40 GMT

hello

if you want to select a range, you should code

Date={'>MinValue<MaxValue'}

Re: Filter between two Date

danosoft — Tue, 26 Jun 2018 15:41:58 GMT

so in my case, how can i change my set analisys?

{<DATA_OUT={">$(=Date($(vFineMonthContrAlt), 'DD/MM/YYYY'))"},DATA_OUT={"<=$(=Date($(vFineMonthContrAltSCAD), 'DD/MM/YYYY'))"}>}

Re: Filter between two Date

olivierrobin — Tue, 26 Jun 2018 15:44:02 GMT

try something like that

{<DATA_OUT={">$(=Date($(vFineMonthContrAlt), 'DD/MM/YYYY'))"}<=$(=Date($(vFineMonthContrAltSCAD), 'DD/MM/YYYY'))"}>}

Re: Filter between two Date

danosoft — Tue, 26 Jun 2018 15:49:31 GMT

Sorry but it set wrong sintax your expression, my expression is that, how can i change it?

Sum({<DATA_OUT={">$(=Date($(vFineMonthContrAlt), 'DD/MM/YYYY'))"},DATA_OUT={"<=$(=Date($(vFineMonthContrAltSCAD), 'DD/MM/YYYY'))"}>} CONSUMO_TOT_ANNUO)

Re: Filter between two Date

sunny_talwar — Tue, 26 Jun 2018 15:50:57 GMT

May be try this

Sum({<DATA_OUT = {">$(=Date($(vFineMonthContrAlt), 'DD/MM/YYYY'))<=$(=Date($(vFineMonthContrAltSCAD), 'DD/MM/YYYY'))"}>} CONSUMO_TOT_ANNUO)

Re: Filter between two Date

olivierrobin — Tue, 26 Jun 2018 15:56:35 GMT

sorry,

maybe like this

{<DATA_OUT={">$(=Date($(vFineMonthContrAlt), 'DD/MM/YYYY'))<=$(=Date($(vFineMonthContrAltSCAD), 'DD/MM/YYYY'))"}>}