Discussion board where members can get started with QlikView.
If I have this 2 tables:
And I want a table that looks like:
And I don't even do join, I just put everything from table 2 in a table, I end up with
What is the best way to get what I want?
I don't want to change the column name.
I am used to use LEFT JOIN ON etc. in mysql and now it seems like it automatic join if you have the same column names.
Go to Solution.
On the Dimensions tab, check "Suppress when value is null" for dimension "C" (or Order).
I suggest you load both the tables and after that create a pivot table on that for A field put condition
=If(A<='a2',A) to get data on for a1,a2 that is you want and see the attached for the solutions
This is just an example. In the real situation A is a Customer and B is an Order. And not every Customer has an Order.
I want a table with all the Customers with an order.
So for this just add order dimention in chart also the data is filter according to your condition and display the Orders also.
Thanks for your reply.
I will try it tomorrow morning.
Use Right join not Left join