Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikvw2019
Contributor
Contributor

Count if Substring/Number True

In My below expression for chart , i need to count the column "c_code" only if the first digit is a 3 , please help me with the syntax. The column has values such as "321" or "3-2-1" 

=Count({<left(C_code,1)={$(3)}>}[C_code])

1 Solution

Accepted Solutions
Frank_Hartmann
Master II
Master II

=Count({<C_code= {"=left(C_code,1) = 3"}>}[C_code])

View solution in original post

2 Replies
Frank_Hartmann
Master II
Master II

=Count({<C_code= {"=left(C_code,1) = 3"}>}[C_code])
qlikvw2019
Contributor
Contributor
Author

Thankyou!