topic Re: Excluding values in expressions in QlikView

Excluding values in expressions

Mon, 03 Oct 2016 16:09:51 GMT

Hello everyone, I have an issue that I am trying to solve. I have been working with qlikview for about a year and a half now. What I am trying to achieve is an expression that will exclude all Part #'s that have not been sold. I am trying to link the part # through the SO Due Date as a null pretty much, SO something like if(SO_MAST.DueDate=0,where(SO_MAST.DueDate >='10/1/2015') and(Part #....... etc. etc. Honestly I have a very slight idea on how to format this expression to make it work the way I need, can someone please help me?

Re: Excluding values in expressions

sunny_talwar — Mon, 03 Oct 2016 16:45:00 GMT

Not sure I understand this if statement

if(SO_MAST.DueDate=0,where(SO_MAST.DueDate >='10/1/2015')

Can you may be elaborate a little?

Re: Excluding values in expressions

Mon, 03 Oct 2016 16:59:02 GMT

Honestly I don't know if the example I gave is correct. What I'm trying to do is get a list of part #'s that are not linked to due dates in the past year by excluding part #'s that are linked to due dates. I hope this helps