I currently have a table which contains a number of field and I have applied various filters to get the desired data. As I need to create some charts I need to change this to set analysis so I can summarise the data.
My current syntax is :
if(VacProgress='In Progress' and
(vacstate<>'Draft' and vacstate<>'In progress'and vacstate<>'Refused') and
not wildmatch(empjobref, '*VCP*'),
Can anyone help me change this expression so it works with set analysis?
Although you see red lines underneath the expression, there might be a good chance that you may still get your solution. The red lines are shown in older versions of QlikView when you use -=. Can you check if after clicking okay do you get a result you expect?