Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Master II
Master II

Re: Count if Substring/Number True

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

View solution in original post

2 Replies
Highlighted
Master II
Master II

Re: Count if Substring/Number True

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

View solution in original post

Highlighted
Contributor
Contributor

Re: Count if Substring/Number True

Thankyou!