Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
How to get count of values from second table based on values present in 1st table , without using joins ?
which means both table are not linked (associated) to each other in qlik terms .
Example : In table 1 i have field : Visitor , which has values A , B ,C etc . Similarly i have a field called Emp in second table .
So i wanted to show count of all the entries of A , B and C in Emp field of second table
I have attached sample data with output .
Sorry Bhai , for not being articulate . However answer to below will help
:Lookup , if found then how many times it's found in non related table . Please Help !
Thanks & Regards
Shekar
Check attached
!
NULLASVALUE '-' ;
Companyvisit:
LOAD Company,
Visitor,
Date
FROM
empvist:
LOAD Emp,
Store,
Date
FROM
abc:
load Visitor as Name,num(Count(Visitor))as cmpnyvisit Resident Companyvisit Group by Visitor ;
join(abc)
xyz:
load Emp as Name,num(Count(Emp))as storevisit Resident empvist Group by Emp ;
a123:
load Name,(cmpnyvisit+storevisit) as total Resident abc ;
DROP Tables Companyvisit,empvist ;
EXIT SCRIPT ;
May be this?
You can make a dummy field and then match it with both the tables(name),
Hi Sunny Bhai ,
Actually i needed only data from Visitor field of Company Visitor table not Emp data ,
what i see in your attachment is , that data from Visitor and Emp both are concatenated .
Also both table should not be related , but currently it is related by date field which should not be the case
Thanks & Regards
Shekar
Hi Praveen ,
As mentioned earlier , join is not the requirement .
I am not sure I follow.... do you want to expand on this a little.
Sorry Bhai , for not being articulate . However answer to below will help
:Lookup , if found then how many times it's found in non related table . Please Help !
Thanks & Regards
Shekar