topic add new column in QlikView

add new column

Wed, 24 Feb 2010 14:57:34 GMT

Hi, i'm new to qlikview, i try to create a new column as a concatenation of two strings present in my table.

I load the table from a db Access as

[ code ]

select * from table

[ /code ]

and i create the new column with [ code ] LOAD value, concat(<field>, ', ') AS field_list FROM <table> GROUP BY value; [ /code ] but it doesn't work, the error refers to the table that it indicated as missing.

thanks

add new column

shumailh — Wed, 24 Feb 2010 15:35:01 GMT

Hello!

If you want to combine two fields then try & or + sign as per your requirement.


LOAD
 Month,
 Year,
 Month&'-'&Year as MnYr
FROM Sales;

Concatenation is an operation that uses two tables and combines them into one. refer Help:

tab1:

Load * from file1.csv;

tab2:

load * from file2.csv;

.. .. ..

Concatenate (tab1) load * from file3.csv;

Regards,
Shumail Hussain

add new column

Thu, 25 Feb 2010 11:59:40 GMT

Thanks,

I use the SQL code:

I load each field ( not with *) and add the new field with '&' to concatenate.

add new column

Fri, 26 Feb 2010 00:56:37 GMT

Hi Shumail:

Can you help me i have a question, how can i add a column in a pivot table chart, for example:

i have this pivot table:

Enterprise Value Value2 Value3

AAA 1 2 3

BBB 1 2 3

CCC 1 2 3

i need to put a new column with the sum of the rows, can you tell me how to do it?

Desire Result:

Enterprise Value Value2 Value3 Total

AAA 1 2 3 6

BBB 1 2 3 6

CCC 1 2 3 6

Regards

Carlos

add new column

Fri, 26 Feb 2010 20:21:18 GMT

I found the solutions after investigation, i was checking a subtotal colum wrong, but anyway my regards to all.