Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
kalyandg
Contributor II

Grouping

Hi all,

please help me to solve this one

i have a account code field

100000000

200000000

300000000

400000000

500000000

1211

1212

........

,,,,,,,,,

2211

2213

..............

..............

..........

3213

3212

...........

..............

4211

4212

............

..............

521

5211

the field in which the first five long values should be account header, so i need those five values to brought out in the another field, so that if we put straight table we can have more description, fisrt account header, next respective account no. to account header and categories

is there any way to do this in script to seperate first five and relate those values  with respective account nos

please help me

6 Replies
phaneendra_kunc
Valued Contributor III

Re: Grouping

Where is the relation between your first 5 long account headers and to the data..

sushil353
Honored Contributor II

Re: Grouping

plz upload your sample data

kalyandg
Contributor II

Re: Grouping

account code and account name is the relation between these fields

khadeer_sparks
Valued Contributor

Re: Grouping

Hi,

PFA

kalyandg
Contributor II

Re: Grouping

hi susil,

i have attached my sample doc here

kalyandg
Contributor II

Re: Grouping

hi,

thanks for ur reply

but i cant understand what you have given

Community Browser