Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Differences of Two files to be shown in one object

Dear Friends/Gurus,

Thanks in advance for helping to resolve issue. Please find issue below:

We have two files data i,e file1 and file2 having similar data structure i.e 3 columns(PB,Dir,Mgr).

There is hirerachy in data. PB-->Dir-->Mgr

We want to show difference of file 1 and file2 data in one object only when same Mgr is present in file1 and file2 but having different PB or Dir i.e at manager level.

When Mgr is present in one table1 and not present in other table2 ...then difference need not be present in object.(we can ignore that record).


Issue is, it is showing differences correctly in object but when selections made in all tables i.e table1(file1data) ,table2(file2data)on

records it is not getting highlighted as there is no associations.

Please help , we need to highlight selections made in table 1 or table2 or table3 in corresponding objects it should show correspondingly in all objects.


Please find attached data,qvw with script and pic which explain issue.



11 Replies
swuehl
MVP
MVP

Create a list box with a field <expression> like

=If([Only in One Table?] or IsAnyDifference, key)

Not applicable
Author

Thank you

its working fine now