topic Re: Set analysis problem with greater than date in QlikView

Set analysis problem with greater than date

andrespa — Fri, 20 Nov 2015 08:47:19 GMT

Hi everyone!

We have a little problem that it's quite common and for what we found lots of examples within the community, but estill we are not able to do it right.

We have this set analysis:

=count({DATE_FC ={"<= $(=AddMonths(Today(),-6))"} >}ID_PROCEDIMIENTO_aux)

We can't figure out what's wrong, someone could please give us a hand.

Thanks in advance.

Andrés

Re: Set analysis problem with greater than date

PrashantSangle — Fri, 20 Nov 2015 08:50:37 GMT

Hi,

firs check your dateformat of DATE_FC and =Addmonths(Today(),-6)

Regards

Re: Set analysis problem with greater than date

santhosh_k_n — Fri, 20 Nov 2015 08:51:23 GMT

hi,

You had missed an angular bracket '<' after starting the set.

Please check.

BR,

Re: Set analysis problem with greater than date

tamilarasu — Fri, 20 Nov 2015 08:52:03 GMT

I guess your DATE_FC field format must be mismatching. What is your date format.

=count({DATE_FC ={"<= $(=Date(AddMonths(Today(),-6)), 'MM/DD/YYYY')"} >}ID_PROCEDIMIENTO_aux)

Change the highlighted format with your field format.

Re: Set analysis problem with greater than date

andrespa — Fri, 20 Nov 2015 08:57:24 GMT

Hi Tamil, done. But still incorrect.

Re: Set analysis problem with greater than date

tamilarasu — Fri, 20 Nov 2015 08:59:13 GMT

Hi Andres,

Did you check the angular bracket as said by Santhosh.

=count({<DATE_FC ={"<= $(=Date(AddMonths(Today(),-6)), 'MM/DD/YYYY')"} >}ID_PROCEDIMIENTO_aux)

Re: Set analysis problem with greater than date

andrespa — Fri, 20 Nov 2015 09:00:36 GMT

Yes Tamil, that was ok from the beginning. It was a transcription error.

Re: Set analysis problem with greater than date

tamilarasu — Fri, 20 Nov 2015 09:04:29 GMT

Andres. What is the result you are getting now.? Could you post your application?

Re: Set analysis problem with greater than date

santhosh_k_n — Fri, 20 Nov 2015 09:07:46 GMT

Hi,

can you save the addmonth function into a variable and asign the variable in set and try.

hope that helps

BR,

Re: Set analysis problem with greater than date

andrespa — Fri, 20 Nov 2015 09:09:00 GMT

We're getting zero as a result, but we know for sure that there's more than 2000 dates that fullfil the condition. It's sintaxis for sure, because even when we put this:

=count({<FECHA_HITO_FORMATO ={"<= 20/11/2015"} >}ID_PROCEDIMIENTO_aux)

or this:

=count({<FECHA_HITO_FORMATO ={"<= '20/11/2015'"} >}ID_PROCEDIMIENTO_aux)

It doesn't work!!!

Re: Set analysis problem with greater than date

andrespa — Fri, 20 Nov 2015 09:10:11 GMT

Hi Santosh, we already did that too and still is wrong!

Re: Set analysis problem with greater than date

jagan — Fri, 20 Nov 2015 09:11:40 GMT

HI,

Try this

=count({DATE_FC ={"<=$(=AddMonths(Today(),-6))"}>}ID_PROCEDIMIENTO_aux)

You can get many examples from below link

Set Analysis for certain Point in Time

Hope this helps you.

Regards,

Jagan.

Re: Set analysis problem with greater than date

effinty2112 — Fri, 20 Nov 2015 09:14:37 GMT

Try this out:

=count({<DATE_FC ={$(=chr(34) &'<=' & AddMonths(Today(),-6) & chr(34))} >}ID_PROCEDIMIENTO_aux)

Hope it helps.

Re: Set analysis problem with greater than date

andrespa — Fri, 20 Nov 2015 09:16:04 GMT

Hi Jagan, thanks a lot!!! Apparently the problem was the spaces between!!!

Cheers,

Andrés