Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

[ASK] how to count certain character?

hello..

i wanna ask, how to count certain character in a word?

example, i have few records in a column

columnA

-------------

mine.A

mine.A.B

bye.A

bye.A.B.C

thanks.A

thanks.A.A.C.D

and i want to know hos much dot (.) character show in every records

how can i do that in qlikview?

many thx...

10 Replies
Not applicable
Author

Awesome, this solution from John also works and its simpler.