Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

LOGIC

Dear All,

I hav a code column and i want to create a group of AA,BA,CA where the logic is that first we have to make a goup of OOO,XXX,BBB and in  that group the like

ABBBB01
ABBBB05
AABBB08

BBOOO02
BAOOO03
BCOOO04

CAXXX01
CBXXX02
CCXXX03
CDXXX04

and then we have to sort the first two alphabet of each group and take the top alphabet  AA , BA, CA in a group..

plz reply soon..

3 Replies
Not applicable
Author

Please find attachement

hope this helps

jagan
Partner - Champion III
Partner - Champion III

Hi Rahul,

Try like this

Code:

LOAD Code,

Mid(Code, 3, 3) AS Group_code,

Left( Code,2) AS SubGroup_code

FROM DataSource;

Regards,

Jagan.

aveeeeeee7en
Specialist III
Specialist III

Hi Rahul

With Reference of Jagan Mohan Code i have worked on the Solution.

See the Attached Files.

Regards

Aviral