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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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