Drill Down Issue

[#1]

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

[JonnyPoole]

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;

[#3]

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;

[JonnyPoole]

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>