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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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.