topic Re: How to make relationship based on PrimaryKey? in QlikView

How to make relationship based on PrimaryKey?

jagannalla — Thu, 25 Aug 2011 07:09:32 GMT

Hi,

To make a relationship between the below 2 tables script i'm getting the error.

Table1:

LOAD ID,

FROM

D:\RTQ\Test.qvd

(qvd);

Left Join(Table1)

LOAD

// ID

Max(A) as MaxA,

Min(A) as MinA

Resident Table1;

- If i comment the ID then it is executing without the error. Even if i comment Left Join(Table1) and uncomment ID it is showing the error.

- One more thing i want to create qvd file for Table1 along with MaxA & MinA fields. To achive this i can taken in the script like this.

Table1:

LOAD ID,

FROM

D:\RTQ\Test.qvd

(qvd);

Left Join(Table1)

LOAD

Max(A) as MaxA,

Min(A) as MinA

Resident Table1;

- I want to see in the table box the Max and Min value for pariticular ID only. Now it shows for all ID's as below image how can i overcome this.

How to make relationship based on PrimaryKey?

lironbaram — Thu, 25 Aug 2011 07:17:04 GMT

hei change your script to this:

Table1:

LOAD ID,

FROM

D:\RTQ\Test.qvd

(qvd);

Left Join(Table1)

LOAD

Max(A) as MaxA,

Min(A) as MinA

Resident Table1

Gropu by ID;

it should work

How to make relationship based on PrimaryKey?

jagannalla — Thu, 25 Aug 2011 07:33:30 GMT

K Thanq..But i'm not able to catch Max an Min of the field.

For Eg:

My output show like this.

How to make relationship based on PrimaryKey?

lironbaram — Thu, 25 Aug 2011 07:44:16 GMT

hei

you wanted to see the max and the min A for every id and that what its displaying

i dont understand what you want can you post an example with the desired result

Re: How to make relationship based on PrimaryKey?

SunilChauhan — Thu, 25 Aug 2011 07:53:37 GMT

see the attched file

Re: How to make relationship based on PrimaryKey?

jagannalla — Thu, 25 Aug 2011 08:01:29 GMT

Hi,

I attached my sample file along with description.

Re: How to make relationship based on PrimaryKey?

lironbaram — Thu, 25 Aug 2011 08:11:10 GMT

hei

look at this

Re: How to make relationship based on PrimaryKey?

SunilChauhan — Thu, 25 Aug 2011 08:21:20 GMT

please see the attached

will this help u?

Re: How to make relationship based on PrimaryKey?

jagannalla — Thu, 25 Aug 2011 08:56:10 GMT

Thanks to helpme...

- I'm using below functionality to Quick load of max field value

Table1:

LOAD ID,

FROM

D:\A\Test.qvd

(qvd);

ALL_A:
Load FieldValue('A',IterNo()) as A1
AutoGenerate(1)
While not Isnull(FieldValue('A',IterNo()));

Max_A:

Load Max(A1) as MaxA resident ALL_A;
Drop table ALL_A;

- Now how can i make a join as below code for above table name Max_A.

Left Join(Table1)

LOAD

Max(A) as MaxA,

Min(A) as MinA

Resident Table1

Gropu by ID;