Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Partner
Partner

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
Highlighted
Partner
Partner

Re: Grouping

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

Highlighted
sushil353
Honored Contributor II

Re: Grouping

plz upload your sample data

Highlighted
Partner
Partner

Re: Grouping

account code and account name is the relation between these fields

Highlighted
khadeer_sparks
Valued Contributor

Re: Grouping

Hi,

PFA

Highlighted
Partner
Partner

Re: Grouping

hi susil,

i have attached my sample doc here

Highlighted
Partner
Partner

Re: Grouping

hi,

thanks for ur reply

but i cant understand what you have given