topic How do i create data hierarchy? in QlikView

How do i create data hierarchy?

sagarpawar — Mon, 23 Apr 2018 07:41:05 GMT

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

Re: How do i create data hierarchy?

techvarun — Mon, 23 Apr 2018 08:09:48 GMT

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

Re: How do i create data hierarchy?

sagarpawar — Mon, 23 Apr 2018 08:38:33 GMT

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.