Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

compare two different fields in the same table

Hi everybody,

I have a doubt, i have a table with information from  all companies, in that table i have details the branches also, i need show in a pivot table the Company with your branches.

In my model i have one table with two field, field1 and field2, those fields should be equals, now i need compare field1 (in 1 row) with all the rows in the table for know the branches.

Please help me, currently i have this expression, but just it evaluate in the same row

= aggr(only({1<field1 ={"=field1=field2"} >}branches),field1)


thank you so much

3 Replies
Not applicable
Author

Hi Lorena,

So what you need is to compare two different columns in the same table (Field1, Field2) to determine the hierarchy between them? something like this:

IdFatherIdName
1John Doe
21Jane Doe
31Paul Doe
4Tom Sawyer
54Mary Sawyer

So John Doe is Jane's and Paul's father, and Mary is Tom Sawyer's child.

Let me know if why I understood is what you meant.

Ryuma,

Not applicable
Author

yes, that it what i need

thank you!

Not applicable
Author

Well I think these two links will help you:

Hierarchies

Hierarchy and Hierarchy Belongs to