Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

sagarpawar
New Contributor III

How do i create data hierarchy?

Hi Team,

We are storing XYZ column data into 5 columns.

Req: If length of data is 2 digit it should be store in Lavel1 column, If its 4 then it should be store in Lavel2 column, If its 7 then it should be store in Level3...etc.

How we are getting data now:

How we actually need:

Help Note: We are getting 1st column value in 2nd column with some additional values, Like

if there is 20 in 1st column(LVL1) then in 2nd column its 20+02=2002. same for next column like value in 2nd column is 2002 then value in 3rd column is 2002+255=2002255.

I need logic at script level not expression Level.

Thanks In advance.

Sagar

SGP
2 Replies
Highlighted
techvarun
Valued Contributor II

Re: How do i create data hierarchy?

Share the clear requirement?  From where the number 1002 comes from?

Highlighted
sagarpawar
New Contributor III

Re: How do i create data hierarchy?

All 1 to 3 Level data is coming from one(XYZ) column and that data we are storing in to 3 columns as per the logic that is if there is 2 digit it should be 1level, if count of value is 4 its should be level 2 and if length of value is 7 its should be store in level 3 column.

Thanks,

Sagar Pawar.

SGP