topic Re: If Statement in QlikView

If Statement

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

Hi,

I need some help with an if statement.

I have the following expression which works,

num(Count (DISTINCT if(BST_QtyOnHand >(0),[Item Number])))-NUM(COUNT(DISTINCT{$<FiscalRecordYear={2016},SKH_Source={'SO'},BST_QtyOnHand={'<>0'}>}[Item Number]))

I need an if statement where if the result of the above is <0, then show '0', otherwise the result of the above statement.

Any ideas?

Thanks

Shamit

Re: If Statement

pooja_sn — Fri, 06 May 2016 15:34:13 GMT

=(if(

num(Count (DISTINCT if(BST_QtyOnHand >(0),[Item Number])))-NUM(COUNT(DISTINCT{$<FiscalRecordYear={2016},SKH_Source={'SO'},BST_QtyOnHand={'<>0'}>}[Item Number]))

)<0,0,

num(Count (DISTINCT if(BST_QtyOnHand >(0),[Item Number])))-NUM(COUNT(DISTINCT{$<FiscalRecordYear={2016},SKH_Source={'SO'},BST_QtyOnHand={'<>0'}>}[Item Number]))

)

Re: If Statement

trdandamudi — Fri, 06 May 2016 15:34:24 GMT

May be like below:

If(num(Count (DISTINCT if(BST_QtyOnHand >(0),[Item Number])))-NUM(COUNT(DISTINCT{$<FiscalRecordYear={2016},SKH_Source={'SO'},BST_QtyOnHand={'<>0'}>}[Item Number])) <0,

num(Count (DISTINCT if(BST_QtyOnHand >(0),[Item Number])))-NUM(COUNT(DISTINCT{$<FiscalRecordYear={2016},SKH_Source={'SO'},BST_QtyOnHand={'<>0'}>}[Item Number])) )

Re: If Statement

sunny_talwar — Fri, 06 May 2016 15:34:54 GMT

May be this:

Num(If(Count (DISTINCT {<BST_QtyOnHand = {'>0'}>} [Item Number]) - Count(DISTINCT{$<FiscalRecordYear={2016},SKH_Source={'SO'},BST_QtyOnHand={'<>0'}>}[Item Number]) < 0, 0, Count (DISTINCT {<BST_QtyOnHand = {'>0'}>} [Item Number]) - Count(DISTINCT{$<FiscalRecordYear={2016},SKH_Source={'SO'},BST_QtyOnHand={'<>0'}>}[Item Number])))

Re: If Statement

shamitshah — Fri, 06 May 2016 21:31:27 GMT

Thanks for your reply.

Solution from both Sunny and Thirumala work.

Once again, thanks for your help.

Shamit