Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am new in qlikview. please help me to resolve that issue.
Thanks In advance.
Query:
I have a field which is containing integer and string.I am using this field as a key to make a connection between two table.
Table1
Field1 Field2 Field4
1 A K
2 b K
3 c M
D d K
Table2
Filed1 Field 3
1 X
2 Y
now I want a drill down group for field1, if(field4='K',Field3,if(Field4='M',Field2,Field1) this expression gives right result what i want but i am not able to drill down the next level.
Please help...
Regards,
Nisha
You can join the 2 tables in the script and then add the expression as a NewField (and dropping the original table). If you do this, you can use the NewField in your drill group at any level.
Temp:
Load ...
from <Table1>
outer join (Temp)
Load ....
from <Table2>
noconcatenate
Data:
load
* .
if(field4='K',Field3,if(Field4='M',Field2,Field1) as NewField
resident Temp;
drop table Temp;
Table1:
LOAD * Inline
[
Field1, Field2, Field4
1,A,K
2,b,K
3,c,M
D,d,K
];
Outer Join(Table1)
LOAD * Inline
[Field1,Field3
1,X
2,Y
];
NoConcatenate
LOAD
Field1,
Field2,
Field3,
Field4,
if(Field4='K',Field3,If(Field4='M',Field2,Field1)) as Field5
Resident Table1;
DROP Table Table1;
Field1 and Filed1 seem to have the same values. You can join them together by aliasing them to have the same name
Temp:
Load Field1,Field2,Field4
from <Table1>
outer join (Temp)
Load Filed1 as Field1, Field3
from <Table2>