Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

display only names with the first letter C?

 

Below is a table with Patient Last Name and all that is in the syntax is PatLName.

 

Find out how we can only display in the table something based on criteria, For example how do I only display a list of names that start with the letter “C”.

 

 

 

1 Solution

Accepted Solutions

Re: display only names with the first letter C?

May be like this

If(Left(PatLName, 1) = 'C', PatLName)

2 Replies

Re: display only names with the first letter C?

May be like this

If(Left(PatLName, 1) = 'C', PatLName)

Not applicable

Re: display only names with the first letter C?

thank you, I really appreciate the help.