topic LOGIC in QlikView

LOGIC

Mon, 17 Feb 2014 06:49:06 GMT

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..

Re: LOGIC

Mon, 17 Feb 2014 07:09:47 GMT

Please find attachement

hope this helps

Re: LOGIC

jagan — Mon, 17 Feb 2014 07:36:46 GMT

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.

Re: LOGIC

aveeeeeee7en — Mon, 17 Feb 2014 10:35:59 GMT

Hi Rahul

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

See the Attached Files.

Regards

Aviral