Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks,
I use the SQL code:
I load each field ( not with *) and add the new field with '&' to concatenate.
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
I found the solutions after investigation, i was checking a subtotal colum wrong, but anyway my regards to all.