topic qualify keyword in QlikView

qualify keyword

Thu, 29 Mar 2012 06:27:25 GMT

i am using 6 different tables product ,orderdetails etc. i have productid and unitprice columns in product and orderdetails table thats why synthetic key issue is troubling me. i used qualify keyword

qualify productid,unitprice;

load statement of product

load statement for other tables

load orderdetails.

when i used qualify keyword like this in that case my unitprice column was showing no values means it became unavailable.

when i use qualify productid;

load product

load other tables

qualify unitprice;

load orderdetails

it worked....

why did this happen??

any problem with using qualify keyword???

i am attaching a pic for better understanding..

qualify keyword

CELAMBARASAN — Thu, 29 Mar 2012 06:45:48 GMT

Hi,

Is unitPrice is same in both product and order details table for the products?If so why not you remove the unit price field from order details field?

Celambarasan

qualify keyword

Thu, 29 Mar 2012 07:15:07 GMT

i think i can it with the as keyword.

but my problem is lot worse i am facing both synthetic key issues and loosely coupled table i am attaching with it the snap of the schema... please help me tackling this issue

qualify keyword

CELAMBARASAN — Thu, 29 Mar 2012 07:25:14 GMT

Hi,

Attach Full schema.In the attached schema only synthetic exists there is not loosely coupled table.

Or post your complete script.

Celambarasan

qualify keyword

Thu, 29 Mar 2012 09:01:06 GMT

qualify keyword

Thu, 29 Mar 2012 09:06:42 GMT

qlik view is telling me that invoices is a loosely coupled table and when i made a selection in productid of product,corresponding values in invoices didnt get selected..why and how to solve it?

Re: qualify keyword

Thu, 29 Mar 2012 10:18:07 GMT

For a start, it looks like you need to qualify PostalCode also as you are causing a circular relationship which is causing the loosely coupled table.

qualify keyword

Thu, 29 Mar 2012 11:59:37 GMT

thnx Matt

i think oderid is also causing the loosely coupled table situation am i rite?

qualify keyword

Thu, 29 Mar 2012 13:41:12 GMT

I don't think so I think. It looks like OrderID is only acting as a relationship between the orders and their order lines which I expect is correct.