Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

souadouert
Contributor III

Set analysis with string function

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)

1 Solution

Accepted Solutions

Re: Set analysis with string function

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)

3 Replies
anderson_system
New Contributor III

Re: Set analysis with string function

hi

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)

MVP
MVP

Re: Set analysis with string function

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

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)

Community Browser