Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shekhar_analyti
Specialist
Specialist

Lookup , if found then how many times it's found in non related table . Please Help !

Hi All ,

My requirement is that there are two tables completely unrelated , it should not be linked , joined as well .

And then values from Field Manager of table A has to been looked up in Field  People in Table B , if found then its count .

Table A

   

ManagerAreaDateA
A12/1/2016
B23/1/2016
C25/1/2016
D16/1/2015
E37/1/2014
F48/1/2018
G49/1/2017
H510/1/2016

Table B

PeopleDate
A2/1/2017
A1/1/2018
B3/1/2017
B3/1/2018
C3/1/2017
F4/1/2017
F4/1/2018
G4/1/2017
G4/1/2018
k4/1/2018
L3/1/2017

                         Output1
ManagerTimes Present in People Column
A2
B2
C1
D0
E0
F2
G2
H0

   

Output2
PeopleDateArea
A2/1/20171
A1/1/20181
B3/1/20172
B3/1/20182
C3/1/20172
F4/1/20174
F4/1/20184
G4/1/20174
G4/1/20184
1 Solution

Accepted Solutions
sunny_talwar

Here is the second output

Capture.PNG

View solution in original post

4 Replies
sunny_talwar

Try this for Output 1

=Count(DISTINCT If(Manager = People, Date))


Capture.PNG

What exactly are you doing for Output 2? Counting the number of Areas?

sunny_talwar

Here is the second output

Capture.PNG

shekhar_analyti
Specialist
Specialist
Author

Thank you Bhai for the reply . When i applied this logic  - > Count(DISTINCT If(Manager = People, Date))

to the real data which is having high volume of data , its making the application slow . Is there any other workaround ?
something like lookup in load script , etc ..

sunny_talwar

Nope!! If you will do calculations with two unconnected tables... you are going to suffer with regards to performance... That is why an association is important. Right now.... you are doing a Cartesian Product of Manager and People to determine the count....