Expression help

hopkinsc — Wed, 19 Dec 2012 13:34:59 GMT

Hi all,

I am wondering if anyone can help me please..

I have the following expression..

Avg ( {<[Job Type]={'Urgent H&S','Offline','Other','Paint'}, OrderComplete_Flag={'1'},Order_QueWIPFlag ={'N'},[SystemCompletedDate]={">=$(=date(Today()-28))<=$(=date(Today()-1))"}>} [Days to Complete(Accepted)])

i need to exclude 10+Operative Names from this average calculation but i didnt want to put all the names in the expression. I was thinking of maybe setting up a variable with the names in then using the variable in the expression but unsure how to do this,

Can anyone help please?

I have done this in the expression which seesm to work

Avg ( {<[Job Type]={'Urgent H&S','Offline','Other','Paint'}, [Operative Name]=-{'Name1','Name2'},OrderComplete_Flag={'1'},Order_QueWIPFlag ={'N'},[SystemCompletedDate]={">=$(=date(Today()-28))<=$(=date(Today()-1))"}>} [Days to Complete(Accepted)])

The field name is

[Operative Name]

Thanks

Re: Expression help

Gysbert_Wassenaar — Wed, 19 Dec 2012 14:06:02 GMT

[Operative Name]=-{'Name1','Name2'} is a perfectly fine solution. If you want to use a variable it needs to contain a string like: 'Name1','Name2','Name3'. Including single quotes and comma's. You can then use the variable in the expression like this: [Operative Name]={$(vNames)}

Re: Expression help

hopkinsc — Wed, 19 Dec 2012 15:31:34 GMT

Hi, thanks very much

topic Expression help in QlikView

Expression help

Re: Expression help

Re: Expression help