Discussion board where members can get started with QlikView.
If I have the following 2 list:
How to get something like this?:
I need to know the cities that matches in 2 lists, and the differences between them.
Go to Solution.
Sure, you could use similar expressions as in the straight table to create new fields in the script.
See attached sample.
Is this like you want it?
hope I got your issue correctly. Please see attached example. I haven't used match function, but simple counts after building a common concatenated table.
(I don't really need the links to the other tables, we can get rid of the links by simple renaming the table3 fields and expression in straight table, if needed.
Hi Stefan, thanks for your help.
Do you know if its possible to get the InCities and NewInCities as dimensions to select and filter the data?
Hi Stefan, it is exactly what i was looking for.
Hi Stefan -
I have a PE for Qlikview can you Explain your approach in a doc file as I have a similar issue.
Thanks in Advance -
This is the script code:
(html, codepage is 1252, embedded labels, table is @1);
(html, codepage is 1252, embedded labels, table is @2);
LOAD CitiesList as AllCities,CitiesList
Concatenate Load Cities as AllCities, Cities
if(count(Cities) and count(CitiesList),'Y','N') as InCities,
if(count(CitiesList)=0 and count(Cities),'Y','N') as NewInCities
resident table3 group by AllCities;