topic Create Field in one table By using field in another table. in QlikView

Create Field in one table By using field in another table.

Thu, 23 Jan 2014 06:05:58 GMT

I have an inline :

items id , item descriptions,

1, Purchase

2,Sale

3,etc

4,Others Reciepts/issues

5,Other Reciepts/Issues

6,..

And I also have another table in which i Got details of quantities.

where quantities have both Negetive and positive values .

Now i need

To Give them quantity details either purchase , or sale or other reciept or issues .But for issues and reciepts, i have to distinguish on the basis of their quantity and id if id is 4 and quantity positive reiciept other wise issues.. please help me. than you.

Here is the attachment also.

Message was edited by: sandeep subedi

Re: Create Field in one table By using field in another table.

sujeetsingh — Thu, 23 Jan 2014 06:11:30 GMT

Sandeep ,

you need to use nested if gor checking the conditions whether to take Reciepts or Issues.

Well can you provide the sample or explain in detail

Re: Create Field in one table By using field in another table.

tresB — Thu, 23 Jan 2014 06:18:11 GMT

I guess you are using applymap(). Try using an IF along with the applymap for such exceptional cases, like:

If(ID=4 , If(Qty>0,'Reciept' , 'Issues'), ApplyMap( 'MapTable' , ID)) as QtyDetails

Re: Create Field in one table By using field in another table.

Thu, 23 Jan 2014 06:51:56 GMT

I have attached one eg above. please Sir , have a look at it once.

Re: Create Field in one table By using field in another table.

Thu, 23 Jan 2014 07:22:10 GMT

Hey sundeep,

do like this then you will get the quantity also

Quantity:

Mapping

LOAD ID,

QTY

FROM

C:\Users\rb4\Downloads\EG.xls

(biff, embedded labels, table is [Sheet1$]);

Consolidated:

LOAD ID,

NAME,

ApplyMap('Quantity',ID) as Quantity

FROM

C:\Users\rb4\Downloads\EG.xls

(biff, embedded labels, table is [Sheet 1$]);

Regards,

Rajesh

Re: Create Field in one table By using field in another table.

Thu, 23 Jan 2014 07:35:22 GMT

In this way I will get purchase , sales , but if i need to distinguish misc reciept or issues that i need to do on the basis of quantity being positive or negetive. how can i solve it out.

Re: Create Field in one table By using field in another table.

Thu, 23 Jan 2014 09:13:38 GMT

Please reply me .