topic Re: Calculated dimension in QlikView

Calculated dimension

Wed, 19 Mar 2014 08:00:40 GMT

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?

Re: Calculated dimension

alexandros17 — Wed, 19 Mar 2014 08:06:36 GMT

HEre is an example

Re: Calculated dimension

MK_QSL — Wed, 19 Mar 2014 08:12:09 GMT

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;

Re: Calculated dimension

rustyfishbones — Wed, 19 Mar 2014 08:33:16 GMT

Try

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

Re: Calculated dimension

veidlburkhard — Wed, 19 Mar 2014 09:00:39 GMT

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