# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for
Did you mean:
Creator II

## Logical Error

Hello Everyone,

I am facing an issue while creating a logic. Require your help

Data:

 A 1 2 2 2 2 3 3 3 3 4 2 2 3 3 4 4

Output:

 A Output 1 1 2 2_1 2 2_2 2 2_3 2 2_4 3 3_2_4_1 3 3_2_4_2 3 3_2_4_3 3 3_2_4_4 4 4_3_2_4_4_1 2 2_5 2 2_6 3 3_2_6_1 3 3_2_6_2 4 4_3_2_6_2_1 4 4_3_2_6_2_2

The logic behind the output is very easy.

Thanking you all in anticipation

Regards

KP

1 Solution

Accepted Solutions
Champion III

See attached and let me know if this helps

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
14 Replies
Partner - Specialist

Hi,

If you explain the logic behind the output (that you say it's easy), it would be easier to help. I couldn't find the pattern.

Eduardo

Champion III

Hi ,

Can you explain the logic so people don't spend time guessing!

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Partner - Champion

Hi,

The logic behind the output is very easy.

BUT YOU NEED TO TELL US WHAT IT IS!

Crystal ball is not working today!

Andy

Creator II
Author

Sorry Guys (@awhitfield, @vinieme12, @eduardo.sommer ) for that lame line; 'Logic behind it is very easy'.

Please see the below image, it is very informative and explains the logic .

The Order of input data will not change. This data would come from SAP

Champion III

This Tree diagram is not informative nor is it explaining the derivation of the node elements!

Can you explain how each item is evaluated?

for example:  4_3_2_4_4_1  and 4_3_2_6_2_2 ??

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Champion III

See attached and let me know if this helps

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Master III

Hi,

Temp:
LOAD A,Autonumber(RowNo(),A) As NR,AutoNumber(A) as Level,RowNo() As Rowno
Inline [
A
1
2
2
2
2
3
3
3
3
4
2
2
3
3
4
4
]
;

Load Rowno,A,If(Level > 2,NewA&AutoNumber(RowNo(),NewA),NewA) as NewA;
If(Level = 1,A,
If(Level = 2,A&'_'&NR,
If(Peek(A) <> A,A&'_'&Peek(NewA)&'_',Left(Peek(NewA),Len(Peek(NewA))-1)))) as NewA
Resident Temp;
Drop Table Temp;

Regards,

Antonio

Champion III

Nice ; but I'd generally avoid Preceding load

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Creator II
Author