topic Set analysis and current selection in QlikView

Set analysis and current selection

Tue, 07 Jun 2011 13:50:28 GMT

Hi everybody,

I have a button that I've configured in this way :

=Date( Max( {1<Compteur = {$(#=Only(Compteur))}>} Date ) )

I've checked the QV Help and the syntax seems to be fine. One detail, Compteur contains text eg. : "Disjoncteur Général"

Does somebody has any idea ?

Thank you

Re: Set analysis and current selection

Tue, 07 Jun 2011 14:01:33 GMT

Hi, I think the problem is that Compteur is a string field and you are trying to cast the string to a number by using $(#=) the pound sign before the equal sign, hence the expression should work written like this:

=Date( Max( {1<Compteur = {'$(=Only(Compteur))'}>} Date ) )

Also rembember, the only function will return a value in the case that only one value is possible, otherwise it will return null.

Regards

Set analysis and current selection

erichshiino — Tue, 07 Jun 2011 14:02:05 GMT

Does it work outside that search string box? In a text box for example?

You probably need quotes around the compteur:

=Date( Max( {1<Compteur = {'$(#=Only(Compteur))'}>} Date ) )

=Date( Max( {1<Compteur = {"$(#=Only(Compteur))"}>} Date ) )

Regards,

Erich

Set analysis and current selection

Tue, 07 Jun 2011 14:18:39 GMT

Thank you Ivan and Erich,

It works when I combined what you told me (without # and with " "):

=Date( Max( {1<Compteur = {"$(=Only(Compteur))"}>} Date ) )

Thank again guys !

Set analysis and current selection

Tue, 07 Jun 2011 15:32:17 GMT

Jeremy, just as a small suggestion, avoid using double quotes when possible, since it will invoke the qv search engine and it might have some performance implications. I always use single quotes, when I am filtering by a literal field value.

Regards

Set analysis and current selection

erichshiino — Tue, 07 Jun 2011 15:35:16 GMT

Good to know that Ivan!

Thanks!

Erich