This content has been marked as final.
Show 5 replies

Re: way to work this formula on Qlik Sense
Gysbert Wassenaar Jul 14, 2016 3:10 AM (in response to June Kim)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)

Re: way to work this formula on Qlik Sense
June Kim Jul 14, 2016 4:13 AM (in response to Gysbert Wassenaar )Thank you so much
It works!

Re: way to work this formula on Qlik Sense
June Kim Jul 17, 2016 8:31 PM (in response to Gysbert Wassenaar )Can you explain that function?

Re: way to work this formula on Qlik Sense
Gysbert Wassenaar Jul 18, 2016 11:47 AM (in response to June Kim)Which one?

Re: way to work this formula on Qlik Sense
June Kim Jul 19, 2016 4:55 AM (in response to Gysbert Wassenaar )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
0
END
2 
IF [SHIP_DT]=[date] and ISNULL([SHIP_DT])=FALSE then
[ORDER_QTY]*[SALE_RPRICE]
ELSE
0
END


