Discussion Board for collaboration related to QlikView App Development.
I have 2 issues.
I am attaching the excel and qvw. When ever currency is USD I want Price 1 column to be displayed. If it's something other than USD then I want Price 2 column
If Status is Post then I want value to be positive else value to be negative displayed in brackets
Please check the attached qvw
Thanks for your help. I was able to do the first one. But for brackets, I am having brackets in all the values instead of the condition, please let me know where I went wrong.
This is my expression
=if(Status = 'Held', NOTIONAL, num(NOTIONAL*-1,'00; (00)')). I am getting all the values in brackets
Thanks a lot. I fixed both the issues with the lead given by you.