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 .
Accepted Solutions
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 ;
