topic Re: IF statement expression in QlikView

IF statement expression

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

Hi,

I need help with the following if expression which is currently incorrect. The statement should show the InwardsMonthYr if PurchaseID <0, otherwise leave it blank.

if(PUR_MYOBPurchaseID=('<0'),max(InwardsMonthYr))

Thanks

Shamit

Re: IF statement expression

avinashelite — Wed, 15 Jun 2016 11:45:43 GMT

Try like

if(PUR_MYOBPurchaseID<0,max(InwardsMonthYr))

Re: IF statement expression

er_mohit — Wed, 15 Jun 2016 11:47:48 GMT

Try This

max(if(PUR_MYOBPurchaseID<0,InwardsMonthYr))

Re: IF statement expression

Chanty4u — Wed, 15 Jun 2016 12:00:12 GMT

try this

if(PUR_MYOBPurchaseID<0,max(InwardsMonthYr))

Re: IF statement expression

ramasaisaksoft — Wed, 15 Jun 2016 12:08:52 GMT

Hi Shamit,

Check the below exp.

here we converted PUR_MYOBPurchaseID into num format .

=If(num(PUR_MYOBPurchaseID)<0,max(InwardsMonthYr))