It seems one of your instructions turned into an emoji but I'm guessing you're referring to conditionally changing the 'D' to 'C' if the Product SKU is 7 or 8.
To do that you can use an 'if' condition with a match function such as below.
if(match([Product SKU],7,8), 'C', [Product Group]) as [Product Group]
This will return 'C' if the SKU is 7 or 8 and if not, will return the original value of [Product Group]
It seems one of your instructions turned into an emoji but I'm guessing you're referring to conditionally changing the 'D' to 'C' if the Product SKU is 7 or 8.
To do that you can use an 'if' condition with a match function such as below.
if(match([Product SKU],7,8), 'C', [Product Group]) as [Product Group]
This will return 'C' if the SKU is 7 or 8 and if not, will return the original value of [Product Group]
Hi, your First Condition is that the Product Group has to be 'A','B','C'AND the Package Type of 'BAG'. This means that you want these two conditions to be resolved together. You do this by wrapping the two conditions in brackets. The Second Condition is 'C' AND 'CARTON' so you wrap both of these in brackets and join the two together with an 'OR'. The brackets are important because you're telling Qlik that the row has to be both Product Group and Package Type to be true.
So the condition would look like this: (First Condition) OR (Second Condition) to be true;
The code would look like this:
if ( (Match([Product Group], 'A','B','C') and Match(upper([Package Type]),'BAG')) or (Match ([Product Group], 'C') and Match (upper([Package Type]),'CARTON')) ,'No', [Flag])
One other thing I noticed is that your search strings were not in the same case as the code you were using. Qlik is case sensitive and so a way you can future proof any potential changes in the contents of your data is to wrap the column in an UPPER( ) function. This will help normalise any potential differences in your column values and guard against any future changes as well.
