QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Valued Contributor

Set analysis problem with greater than date

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:

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

Andrés

1 Solution

Accepted Solutions
MVP & Luminary

Re: Set analysis problem with greater than date

HI,

Try this

You can get many examples from below link

Set Analysis for certain Point in Time

Hope this helps you.

Regards,

Jagan.

13 Replies

Re: Set analysis problem with greater than date

Hi,

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Contributor II

Re: Set analysis problem with greater than date

hi,

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

BR,

SK

MVP

Re: Set analysis problem with greater than date

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

Change the highlighted format with your field format.

Valued Contributor

Re: Set analysis problem with greater than date

Hi Tamil, done. But still incorrect.

MVP

Re: Set analysis problem with greater than date

Hi Andres,

Did you check the angular bracket as said by Santhosh.

.

Valued Contributor

Re: Set analysis problem with greater than date

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

MVP

Re: Set analysis problem with greater than date

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

Contributor II

Re: Set analysis problem with greater than date

Hi,

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

hope that helps

BR,

SK

Valued Contributor

Re: Set analysis problem with greater than date

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!!!