Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Afternoon,
total novice user with probably an even more novice question... How do you use the "and" function in Qlik. My expression is below;
IF([plantype]='Managed Service','Managed Service',
IF([plantype]='Pre Sales','Pre Sales',
IF([plantype]='Service Desk','Service Desk',
IF([plantype]='Product', 'Product',
IF([Customer]='Internal' and [Task]='Horizon Programme','Horizon',
IF([Customer]='Internal','Departmental',
IF([Customer]='Multiple','Departmental',
IF([Customer]='Standard Activity','Standard Activity',
IF([financialbudget]='Overhead','Customer NonBillable',
IF([financialbudget]='Maintenance & Support','Service Desk',
IF([Task]='Unassigned to Work (Enter Remarks)','Unassigned','Customer Billable')))))))))))
I have tried taking this straight from Excel "If(And(" approach which as expected didn't work. However I have tried both replacing the comma in the bold line of text with both "and" and "&&" and I can still not get anything to return as "missing right parenthesis"
Finding it a little frustrating to say the least as there are so many examples of people asking this question and nearly every answer is telling them to achieve what they want in a different way... all of which made sense to be fair, but not helpful in providing me with any insight.
Any help would be greatly appreciated.
TIA
Are you looking to check if Task = Horizon Programme or Task = Horizon? Is this what you want?
IF([Customer]='Internal' and [Task]='Horizon Programme','Horizon',
so what this should be checking is if the customer = internal and the task = horizon programme then the outcome of the expression should be Horizon.
You need to use pick and match for multiple values
all of the examples I have found are only showing this working if all of the matches are in the same column. additionally, I haven't seen any with multiple criteria for the same return. have you any examples of a basic query with matches being found in more than one column and also including an example of the "and" expression (or whatever works with Pick(Match()) best).
Thanks
Having reviewed some more articles on this site it appears that "and"/ "&&" are not functions that can be used in a calculated field. having removed the and section of the expression has worked. this is still however in the nested if statement I have shared above. I do want to understand the pick match functions better so will try and get it working like that.
Thanks for your help
Two things:
1) Where exactly are you trying to use this? Front end? Back end? If Front end, then which kind of object?
2) Would you be able to share a sample where we can see the issue?