topic Need logic help to write nested if condition. in QlikView

Need logic help to write nested if condition.

lalitkgehlot89 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

In Attached data need logic help to write the nested if condition.

I need only the rows with below mention condition.

1) [Location Code]=209931 and [Entry Type]=0 and left([Gen_ Bus_ Posting Group],4)='VEND' and [Quantity]>0 as Purchase

[Location Code]=209931 and [Entry Type]=0 and left([Gen_ Bus_ Posting Group],4)='VEND' and [Quantity]<0 as PurchaseReturn

2) Location Code :- GC/SR/016 and [Entry Type]=4 and [ReceiptFROM]=209910,RECD-M,DTG-SYMP,SYMP,HARMONY-M,MFG-EMB,209920,209932,GC/WH/50,209915 and [Quantity]>0 as Purchase

Location Code :- GC/SR/016 and [Entry Type]=4 and [ReceiptFROM]=209910,RECD-M,DTG-SYMP,SYMP,HARMONY-M,MFG-EMB,209920,209932,GC/WH/50,209915 and [Quantity]<0 as PurchaseReturn

3) Location Code :- 209910 and [Entry Type]=0 and left([Gen_ Bus_ Posting Group],2)<>'IN' and [Quantity]>0 as Purchase

Location Code :- 209910 and [Entry Type]=0 and left([Gen_ Bus_ Posting Group],2)<>'IN' and [Quantity]<0 as PurchaseReturn

Location Code :- 209910 and [Entry Type]=0 and left([Gen_ Bus_ Posting Group],2)='IN' and [Quantity]>0 as INWARD

Location Code :- 209910 and [Entry Type]=0 and left([Gen_ Bus_ Posting Group],2)<'IN' and [Quantity]<0 as OUTWARD

Re: Need logic help to write nested if condition.

adamdavi3s — Wed, 15 Mar 2017 08:10:12 GMT

Personally I would add these as columns in the load script rather than trying to do it in the front end..

but either way just do if() + if() + if()

so:

If([Location Code]=209931 and [Entry Type]=0 and left([Gen_ Bus_ Posting Group],4)='VEND' and [Quantity]>0, sum(yourfield),0)

if([Location Code]='GC/SR/016' and [Entry Type]=4 and [ReceiptFROM]=209910,RECD-M,DTG-SYMP,SYMP,HARMONY-M,MFG-EMB,209920,209932,GC/WH/50,209915 and [Quantity]>0, sum(yourfield),0)

if([Location Code]=209910 and [Entry Type]=0 and left([Gen_ Bus_ Posting Group],2)<>'IN' and [Quantity]>0, sum(yourfield),0) as Purchase

Re: Need logic help to write nested if condition.

lalitkgehlot89 — Wed, 15 Mar 2017 08:35:50 GMT

Hi Adam,

I want to create the field on backend.

Re: Need logic help to write nested if condition.

adamdavi3s — Wed, 15 Mar 2017 08:37:36 GMT

yep so just write that as a preceeding load in your script