topic Re: Set analysis with string function in QlikView

Set analysis with string function

souadouert — Wed, 21 Feb 2018 10:51:02 GMT

HELLO

I didn't found the error in this expression :

=count({<DATE={'<= $(DATE_EXT)'}, DATE_OUVERTURE = {'=RIGHT(DATE_OUVERTURE,2)) = RIGHT($(ANNEE_EXTRACTION),2) '}>}id)

Re: Set analysis with string function

Anonymous — Wed, 21 Feb 2018 11:46:59 GMT

at first it seems to me that there is something missing in the highlighted part of the expression.

=count({<DATE={'<= $(DATE_EXT)'}, DATE_OUVERTURE = {'=RIGHT(DATE_OUVERTURE,2))

= RIGHT($(ANNEE_EXTRACTION),2) '}>}id)

Re: Set analysis with string function

tresB — Wed, 21 Feb 2018 11:55:16 GMT

Not seeing an error (rather, an error highlighting), doesn't guarantee that the expression would give you expected output. It only indicates that, in someway the expression could be parsed to a a valid syntax. And to identify why your expression not working per se, would require more information. Could you share a sample file?

Re: Set analysis with string function

sunny_talwar — Wed, 21 Feb 2018 12:05:53 GMT

May be these few things

1) Don't have space between >= and your dollar sign for set modifier for DATE

2) Use double quotes for search strings

3) May be you need an equal sign for the dollar sign expansion

=Count({<DATE = {"<=$(=DATE_EXT)"}, DATE_OUVERTURE = {"=Right(DATE_OUVERTURE, 2)) = Right($(ANNEE_EXTRACTION), 2)"}>} id)

or this

=Count({<DATE = {"<=$(=$(DATE_EXT))"}, DATE_OUVERTURE = {"=Right(DATE_OUVERTURE, 2)) = Right($(ANNEE_EXTRACTION), 2)"}>} id)