SQL statements load script editor(Qlik sense)

[#1]

Hello, Can someone help me out with understanding, how does one mimic a SQL where clause in the QLIK sense load script editor ?

Also, I am trying to use a sql query to pull some data from multiple tables using left joins followed by a where clause to capture dates in a dynamic range of 1 month going back from today. Any help is appreciated.

[OmarBenSalem]

I found it !

He have to add the 1 also before the P:

=Sum(distinct {1<User =P({1<Customer={"=Count({1}Distinct User)=2"}>} User ) >}  Counter)

ps: Gautam use this final expression; that's the correct one.

Thanks again stalwar1‌

[#3]

So I used the formula you guys provided above, what's happening is that it's creating a static table and filtering the user list based on the selected user does not work unless I remove the '1' that Omar mentioned, in which case it only shows the selected user.

From what I understood: the formula finds all the users that were present on Customers that had two unique users each. That is great but I would need the selection to be based on the Customer's common between the selected user and the other users.

I expanded the dataset to include more combinations.

User	Customer	Counter
A	Cus A	1
B	Cus A	1
F	Cus A	1
C	Cus B	1
C	Cus C	1
D	Cus C	1
A	Cus D	1
B	Cus E	1
C	Cus E	1
F	Cus Z	1

So in this case if I selected 'User A' the table 1 should be shown and table 2 if 'B' is;

So it's still looking for customers with distinct users >=2 but one of the users must be the selected user.

I appreciate all your help and sorry for causing any confusion.

[#4]

Hey guys, any luck ?