Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
barbawawa
Contributor III
Contributor III

Compter avec condition

Bonjour à tous,

J'aimerais compter le nb de ID_MSG qui contient le texte "K103", mais je sèche, avez-vous une idée ? je vous mets une capture en PJ .

 

Par avance merci et bonne journée !!! 

1 Solution

Accepted Solutions
PrashantSangle

try this

=count(if(WildMatch([Corps du message émis],'*K103*'),[Identifiant Msg]))

Regards,

Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

7 Replies
PrashantSangle

try

count({<COPRS_MSG_EMIS={"*K103*"}>}ID_MSG)

or

if(wildmatch(COPRS_MSG_EMIS,'*K103*'),count(ID_MSG)

 

Regards,

Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.
barbawawa
Contributor III
Contributor III
Author

Hello,

Many thanks for your help, but it doesn't work 😞

PrashantSangle

are you getting any error?? can you provide some sample data in excel on which I can try the solution before suggesting any solution.

Great dreamer's dreams never fulfilled, they are always transcended.
barbawawa
Contributor III
Contributor III
Author

no error, it count, but regardless of the condition. in attachement , the excel file

PrashantSangle

try this

=count(if(WildMatch([Corps du message émis],'*K103*'),[Identifiant Msg]))

Regards,

Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

barbawawa
Contributor III
Contributor III
Author

Many many thanks to you, it's working fine !!!

Have a good day

PrashantSangle

great. can you like the reply also.

Great dreamer's dreams never fulfilled, they are always transcended.