I have one table, which contains fields A, B, C, D, E.
My requirement is i want to merge 3 fields as one field
like A,B, C as A1,
B,C,D as B1
And for these A1, B1 Again i have to create one field as follows
is there any possibility in Qlikview?
Please help me on this
Though not very clear, you can try:
A1&B1 as TOTAL
A&B&C as A1
B&C&D as B1
note: '&' is string concatenation operator, if you want to add the numeric values you can similarly use '+' like:
Load A+B+C as A1 ....
I have one table which contains fields COMPANY, COMPANY_2,STATE . Requirement is I want to show COMPANY, COMPANY_2,STATE as Address filed in list box as follows
Please can anyone help on this.
use like this ,
load * inline [
LOAD city &' '& state &' ' & country&' ' & hno as addres Resident Address;