Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculated dimension

Hi, Guys,

I`ve some trouble. I have two tables of data. From the store and from the warehouse. Like in tables below.

Purchase no.

Agent

1

Tom

2

John

3

Steve

4

John

5

John

6

Steve

Purchase no.

Stockman

1

Rick

3

Jeff

4

Rick

6

Rick

I need to select only purchases that has no stockman. Any suggestions?

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

HEre is an example

View solution in original post

4 Replies
alexandros17
Partner - Champion III
Partner - Champion III

HEre is an example

MK_QSL
MVP
MVP

T1:

LOAD *, Purchase as PID Inline

[

  Purchase, Stockman

  1,Rick

  3,Jeff

  4,Rick

  6,Rick

];

T2:

LOAD * Inline

[

  Purchase,Agent

  1,Tom

  2,John

  3,Steve

  4,John

  5,John

  6,Steve

] Where Not Exists(PID,Purchase);

Drop Field PID;

rustyfishbones
Master II
Master II

Try

=IF(ISNULL(Stockman),'No Stockman',Stockman)

veidlburkhard
Creator III
Creator III

Hi Dominykas,

you can solve the problem in your script. See below:

Agent:

LOAD * Inline [

PurchaseID,Agent

1,Tom

2,John

3,Steve

4,John

5,John

6,Steve

];

Join(Agent)

LOAD * Inline [

PurchaseID, Stockman

1,Rick

3,Jeff

4,Rick

6,Rick

];

NoConcatenate

Purchase:

LOAD *

Resident Agent Where IsNull(Stockman);

DROP Table Agent;

Enjoy

Burkhard