How to search a string in a Field with a dynamic variable?

[#1]

Hi,

I have an expression witch find how many times the string appear in a Field :  = count( DISTINCT {Field="DER.5"}   Field )

Now i want to improve the expression with a dynamic variable!

Indeed,

I have another field : Month (jan, feb,...)

and I want when I clik on the January The string to find is "DER.1"   and February the string become : "DER.2", for March "DER.3"  etc...

Do you an idea?

Thanks.

[#2]

I have this expression to convert the Field to a number:

    mixmatch(Month,  'janv.' , 'févr.' , 'mars' , 'avr.' , 'mai' , 'juin' , 'juil.' ,'août' , 'sept.' ,'oct.' , 'nov.' , 'déc.' )

[CELAMBARASAN]

Hi,

     Check with this

     = count( DISTINCT {Field="DER.$(mixmatch(Month,  'janv.' , 'févr.' , 'mars' , 'avr.' , 'mai' , 'juin' , 'juil.' ,'août' , 'sept.' ,'oct.' , 'nov.' , 'déc.' ))"}   Field )

     Or

= count( DISTINCT {Field={'DER.$(mixmatch(Month,  'janv.' , 'févr.' , 'mars' , 'avr.' , 'mai' , 'juin' , 'juil.' ,'août' , 'sept.' ,'oct.' , 'nov.' , 'déc.' ))'}}   Field )

[#4]

Thanks for your answer,

But it seems that it does not work.

Another solution?

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

Try with something like

Count({< Field = {"DER.$(=MixMatch(Month, 'janv.', 'févr.', 'mars', 'avr.', 'mai', 'juin', 'juil.', 'août', 'sept.', 'oct.', 'nov.', 'déc.'))"} >} Field)

Hope that helps.

Miguel

[#6]

Thank you Miguel,

This is perfect!