topic Re: way to work this formula on Qlik Sense in QlikView

way to work this formula on Qlik Sense

Thu, 14 Jul 2016 04:35:43 GMT

Try to use this formula below, but Qlik Sense doesn't allow me to do so..

Can someone edit this to work on the Qlik S please?

Thank you

if(isnull([SHIP_DT]=False and isnull([P_RETURN_DT])=False)) then

(sum([SALE_RPRICE])*([ORDER_QTY]))*(-1)

elseif (isnull([SHIP_DT])=False and isnull([P_RETURN_DT])=True) then

(sum([SALE_RPRICE])*([ORDER_QTY]))

else

END

Gysbert_Wassenaar — Thu, 14 Jul 2016 07:06:19 GMT

Perhaps like this: sum({<SHIP_DT={'*'}>}SALE_RPRICE*ORDER_QTY) * If(IsNull(P_RETURN_DT),1,-1)

If P_RETURN_DT is a date field, i.e. a number too, then you could try

sum({<SHIP_DT={'*'}>}SALE_RPRICE*ORDER_QTY) * -Alt(P_RETURN_D/P_RETURN_D,-1)

Thu, 14 Jul 2016 08:13:59 GMT

Thank you so much

It works!

Mon, 18 Jul 2016 00:31:35 GMT

Can you explain that function?

Gysbert_Wassenaar — Mon, 18 Jul 2016 15:47:44 GMT

Which one?

Tue, 19 Jul 2016 08:55:23 GMT

Can you fix these two formulas?

1 -

IF [P_RETURN_DT]=[date] and ISNULL([P_RETURN_DT])=FALSE then

[ORDER_QTY]*[SALE_RPRICE]*-1

ELSE

END

2 -

IF [SHIP_DT]=[date] and ISNULL([SHIP_DT])=FALSE then

[ORDER_QTY]*[SALE_RPRICE]

ELSE

END