Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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
A1 |
---|
A |
B |
C |
B1 |
---|
B |
C |
D |
TOTAL |
---|
A1 |
B1 |
is there any possibility in Qlikview?
Please help me on this
Thanks,
Vamsi.
May be like attached sample
Though not very clear, you can try:
Load
A1,
B,
A1&B1 as TOTAL
;
Load
A&B&C as A1
B&C&D as B1
From <>;
note: '&' is string concatenation operator, if you want to add the numeric values you can similarly use '+' like:
Load A+B+C as A1 ....
hi
can you give data sample
Reddy ,
It is confusing little bit.
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.
Thanks,
Chiru
Hi
use like this ,
Address:
load * inline [
city,state,country,hno
chennai,tamilnadu,india,14
hyd,AP,india,23
];
LOAD city &' '& state &' ' & country&' ' & hno as addres Resident Address;
May be like attached sample
HI tresesco,
This is exactly what i'm expecting is
Thanks for your support on this.
Thanks,
Vamsi