Discussion Board for collaboration related to QlikView App Development.
hi to all qlicker's ,
i have NAMES and CITIES , I need to show comparatively numbers of visits of NAMES that visited in a CITY ,
with the others CITIES , for example , if we look at London we can see that Mira and Jecob visit there -> So its 2 ,
Now we check Mira and Jecob in Jerusalem and we see that they also visit there -> So its 2 ,
Now we check Mira and Jecob in New York and we see that only Mira visit there -> So its 1 ,
Now we check Mira and Jecob in Mumbai and we see that they also visit there -> So its 2 .
.. and so on ... ( Mira and Hana and Jecob visit Jerusalem )
I need to show in a table or chart or anything the wanted Solution :
i know its hard - but its fun , THANKS.
Create a cartesian product:
LOAD * INLINE [
LOAD NAME as NAME, CITY as CITY2 RESIDENT T1;
Then use CITY and CITY2 as dimensions in a pivot table and count(CITY) as expression
View solution in original post
Create a straight table with CITY as dimension and these for expressions:
hi Gysbert, i understand , it is a nice solution for now , but i have many cities and i need something dynamic , is it possible ?
WOW , so simple and so smart - THANKS Gysbert !!