Qlikview Do Not Select Record that starts with Number

[#1]

Hello,

How can I do this? I have to select a certain amount of records that start with, a,b,c or whatever, but no numbers. How can I do this the most efficiënt way?

[tresesco]

you can check if the first character is numeric or not like:

IsNum(Left(trim(YourField),1))

[kaushiknsolanki]

Hi,

     If you want to select such records from listbox then you can use the search option of listbox and start typing "a*", this will show you the records which starts with "a", then you can press "Enter" to select those records.

     If you want to select such record in expression (Meaning show the data of only those records which starts with a) then the expression will be as below.

     Sum({<Field = {"a*"}>}Sales)

Regards,

Kaushik Solanki

[rbecher]

Do you mean in a SQL SELECT statement or a selection in a listbox??