Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgandhi715
Contributor III
Contributor III

Question on Data modeling

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.

1 Solution

Accepted Solutions
Not applicable

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

View solution in original post

6 Replies
Not applicable

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

vinay_hg
Creator III
Creator III

use product table products column in the filter that will work

nikhilgandhi715
Contributor III
Contributor III
Author

Hi Anand,

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

nikhilgandhi715
Contributor III
Contributor III
Author

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.

Not applicable

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

nikhilgandhi715
Contributor III
Contributor III
Author

Hi Anand,

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