topic Column Hiding and conditional sign value in QlikView

Column Hiding and conditional sign value

Thu, 21 Jan 2016 21:58:45 GMT

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

Kindly help

Thanks

Re: Column Hiding and conditional sign value

NareshGuntur — Thu, 21 Jan 2016 22:17:39 GMT

Please check the attached qvw

Re: Column Hiding and conditional sign value

Mon, 25 Jan 2016 14:39:50 GMT

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

Re: Column Hiding and conditional sign value

Mon, 25 Jan 2016 20:03:33 GMT

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

Re: Column Hiding and conditional sign value

Wed, 27 Jan 2016 14:32:07 GMT

Thanks a lot. I fixed both the issues with the lead given by you.