topic Re: Drill Down Issue in QlikView

Drill Down Issue

Tue, 02 Dec 2014 19:23:02 GMT

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

Re: Drill Down Issue

JonnyPoole — Wed, 03 Dec 2014 02:18:41 GMT

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;

Re: Drill Down Issue

Wed, 03 Dec 2014 02:30:34 GMT

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;

Re: Drill Down Issue

JonnyPoole — Wed, 03 Dec 2014 02:51:00 GMT

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>