Discussion Board for collaboration on QlikView Scripting.
Good Morning, I need help to know how to count the number of vowels and consonants of a text with letters and numbers.
I have attached the QVW, to see what i have.
To resume, I have a lot of vehicle license plates that some of them have this kind of format:
X X 1 2 3 4
and the new ones (after 2007)
X X X X 1 2
I need to order them by new plates and old plates according to the number of letters that they have.
Please help Me.!!
Go to Solution.
You can try this
Where the value is 2, the plate is old and where the value is 4, the plate is new.
Here is the one with the sorting first by New/Old criteria and then within each of them in A->Z
Thanks you very much.
It works according what I wanted!
Super, please close the thread by marking correct and helpful responses.
Qlik Community Tip: Marking Replies as Correct or Helpful