Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is it possible to compare the two list which contains the hierarchy and highlight only those which are not there in one another. Can someone please help me on that?
Basically I'm trying to load the old and new hierarchy into a qvw. Later I'm showing the hierarchy in a list box. Now the user would like to know what was new thing that got added into new hierarchy. So whatever is new but in hierarchy I want to highlight only those values. Could you please help!
It is little urgent
Thanks in advance
Any help or suggestions from anyone on this please?
Hi qlikviewforum,
one solution could be:
table1:
LOAD
*,
AutoNumber(Hierarchy1) as %HierarchyID
Inline [
Hierarchy1
Asia/China/Peking
Asia/Japan/Tokyo
Europe/Germany/Berlin
Europe/UK/London
Europe/France/Paris
Europe/France/Lyon
America/US/Washington
];
table2:
LOAD
*,
AutoNumber(Hierarchy2) as %HierarchyID
Inline [
Hierarchy2
Asia/China/Peking
Asia/Japan/Tokyo
Europe/Germany/Berlin
Europe/Germany/Hamburg
Europe/UK/London
Europe/France/Paris
America/US/Washington
];
hope this helps
regards
Marco
Hi Marco,
Thanks for your help! I have done in the following way. It will be useful for the other users who are looking for the same.
First I have loaded the OLD hierarchy and then loaded the NEW hierarchy. While loading the new hierarchy using the LOOKUP function I have found what is new in the new hierarchy and flagged it as NotMatched. Then I used the same field in the list box selected the NotMatched value and I have locked it so that changes are highlighted in the hierarchy list box. Later I have hided the locked list box as it was no more required.
Further questions on this,
Now the new requirement from the customer is to highlight what is not there in the new hierarchy but it is there in the old hierarchy? I cannot again use the LOOKUP as I'm loading the old hierarchy first and then the new hierarchy. So to find out the what is there is in the old hierarchy but not there in the new hierarchy. I need to load the new hierarchy first and the old hierarchy. It is like loading the data again and again to achieve the result. This I want to do that.
Can someone help me out how to highlight the difference with something similar to what I did to compare the old and new hierarchy. Please let me know your suggestions. It is little urgent.