topic Pivot Table Columns in QlikView

Pivot Table Columns

Thu, 09 Dec 2010 20:57:36 GMT

Hi,

Is it possible to have two dimensions in single column? Say, Customers and Suppliers data being in same column.

Thu, 09 Dec 2010 21:30:36 GMT

Sure, create a calculated dimension:

Customers & ' ' & Suppliers

Thu, 09 Dec 2010 21:45:31 GMT

Thanks Miller.

By i would like to see them in rows and not by concatenating

Here is my explanation.

Customer Table

Supplier Table

I would make selection in customer table as C1,C2 and Supplier table as S1

My result table should be

Client Table

Thu, 09 Dec 2010 21:50:55 GMT

Then you would need to Concatenate the table (Union in SQL).

LOAD CustomerID As ClientID FROM Customer;
CONCATENATE LOAD SupplierID As ClientId FROM Supplier;

For Concatentate/Union, the table must have the same fields. If they don't you need to normalize them so they do.