Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

conditions with set analysis

Hi all!

I am trying to use set analysis in my expression to do something such as a 'like' or a 'substring'.

I have tried many methods but I don't have the result I expect.

The code:

if (getselectedcount(ANNEE)>0 and getselectedcount(MOIS)>0, Count(
{$ < ANNEEEVENEMENT = {$(=getfieldselections(ANNEE, ','))}, MOISEVENEMENT = {$(=getfieldselections(MOIS, ','))}, TYPE_EVENEMENT = {"like '%recours%'"} >}
ID_MESURE), Count(
{$ < TYPE_EVENEMENT = {"like '%recours%'"}, ANNEEEVENEMENT = {$(=year(today()))}, MOISEVENEMENT = {Mar} >}
ID_MESURE))

I think my problem is the {"like '%recours%'"}

I have also tried to create a variable vEvenement = substringcount(TYPE_EVENEMENT, recours) and use the expression ...{$ < vEvenement = {">0"} ...

I have also tried vEvenement = mid (TYPE_EVENEMENT, index(TYPE_EVENEMENT, 'recours'), 7) and use the expression ...{$ <vEvenement = {"recours"} ...

Probably I have mistakes in my expressions but I don't have the right results.

Thanks!

1 Reply
Not applicable
Author

I got the result with something like "field name" = {"*recours*"}. It was a mistake from my part I used the wrong field name.

Thanks