add new column

[#1]

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

[shumailh · Accepted solution]

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

[#3]

Thanks,

I use the SQL code:

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

[#4]

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

[#5]

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