topic Re: Question on Data modeling in QlikView

Question on Data modeling

nikhilgandhi715 — Wed, 08 Oct 2014 08:30:18 GMT

Hi All,

I have total 20 products in my products table; however in the order table i have data for 15 products only. In my listbox I want to display all these products even if there are no orders to it.

I tried inserting a different table for all the products, but it is not working.

Any help would be much appreciated.

Thanks and regards,

Nikhil Gandhi.

Re: Question on Data modeling

Wed, 08 Oct 2014 09:04:50 GMT

Dear Nikhil,

Just outer join both tables Products and Orders and all the products will be in Product Field whether It is sold or not.

Thanks & Regards

Prince Anand

Re: Question on Data modeling

vinay_hg — Wed, 08 Oct 2014 09:14:24 GMT

use product table products column in the filter that will work

Re: Question on Data modeling

nikhilgandhi715 — Wed, 08 Oct 2014 11:24:08 GMT

Hi Anand,

Could you please let me know what Syntax do I need to use, as I am not joining the tables in Oracle?

Re: Question on Data modeling

nikhilgandhi715 — Wed, 08 Oct 2014 11:25:48 GMT

Hi Vinay,

I tried doing it, but it takes only those products where I have data in the Fact table while I need to display all the products.

Re: Question on Data modeling

Wed, 08 Oct 2014 11:30:09 GMT

Dear Nikhil,

Load Both Tables Product and Orders and outre join them like:-

load productname,

productid from products;

join

load orderid,

productid from orders;

then after reload you have one field with productid and productname and one with orderid and then use that productname as filter .

you have all the products in that field.

Thanks & Regards

Prince Anand

Re: Question on Data modeling

nikhilgandhi715 — Wed, 08 Oct 2014 11:37:18 GMT

Hi Anand,

It worked just what I was looking for. Thank you very much for the help, really appreciate.