Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Edditing formula

Having hard time figuring out this formula below works on Qlik Sense.

Is there anyone who knows how to make it works?

if(isnull([ship_dt]) = false and isnull([p_return_dt])=false) then

[수주금액]*(-1)

else if (isnull([ship_dt])=false and isnull([p_return_dt])=true) then

[수주금액]

else

0

end

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

See your other discussion with the same question: way to work this formula on Qlik Sense

Please try to avoid posting the same question twice.


talk is cheap, supply exceeds demand