Discussion board where members can get started with QlikView.
I have a field "Category" whose values are
How can I dynamically filter so that I want only fields which starts with "1. ABC", 2. DEF, ......"10. DEX"
and remove fields that have only numbers and starts with unwanted texts (145365, ABCDEF, GHID)
Go to Solution.
So, the pattern is that it will be a number before . and text after .? May be this
Where IsNum(Trim(SubField(Category, '.', 1))) and IsText(Trim(SubField(Category, '.', 2)))
thank you @sunny_talwar