Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Qlikview Do Not Select Record that starts with Number

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?

3 Replies
MVP
MVP

Re: Qlikview Do Not Select Record that starts with Number

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

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

Re: Qlikview Do Not Select Record that starts with Number

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

MVP
MVP

Re: Qlikview Do Not Select Record that starts with Number

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

Community Browser