topic Re: if stmt in QlikView

if stmt

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

I need to have something in the script like the below -

IF len (product) < 0 and isnull(product) then costprice else saleprice

any suggestions

Re: if stmt

raadwiptec — Wed, 21 Jun 2017 11:25:13 GMT

IF len (product) < 0 and isnull(product) then costprice else saleprice as PRODUCT PRICE

Re: if stmt

PrashantSangle — Wed, 21 Jun 2017 11:26:01 GMT

Hi,

try like

if(len(trim(product))=0,costprice,saleprice)

In this case you dont required to test isnull()

Regards,

Prashant

Re: if stmt

PrashantSangle — Wed, 21 Jun 2017 11:27:38 GMT

len(product) < 0 ????

Can you give example of this case???

Regards,

Re: if stmt

Anil_Babu_Samineni — Wed, 21 Jun 2017 11:28:49 GMT

May be this?

If(Len(Product) = 0, If(IsNull(Prodcut), Sum(costprice), Sum(saleprice)))

Re: if stmt

raadwiptec — Wed, 21 Jun 2017 11:31:20 GMT

MEXAMPLE -- MY PRODUCT data goes something like this MFELKAB etc..

so in many cases my source is blank or null. So i need to check both conditions i.e product shows as blank or - (null)

Re: if stmt

PrashantSangle — Wed, 21 Jun 2017 11:40:14 GMT

Hi,

- does not indicate null.

You can write like

If(len(trim(fieldName))=0 or trim(fieldName)="-",costPrice,SalesPrice)

Regards,

Re: if stmt

raadwiptec — Wed, 21 Jun 2017 11:52:11 GMT

all the above is only working for len .. for null part it is not working i tried both isnull and trim(product) = '-'

Re: if stmt

Anil_Babu_Samineni — Wed, 21 Jun 2017 11:53:30 GMT

Will you provide few rows related the combination of data and better if you provide expected result

Re: if stmt

PrashantSangle — Wed, 21 Jun 2017 11:59:42 GMT

Hi,

If there is space in field then isnull() wont work.

So you have to use len(trim(product))=0

If this wont help you then provide some sample data or share your screen shot of what you tried.

Regards,

Re: if stmt

BalaBhaskar_Qlik — Wed, 21 Jun 2017 12:06:41 GMT

=IF((Len(Trim(product)) = 0 or IsNull(product)), costprice, saleprice)