Lets say i have a mapping table for marketing team where they can create conditions for the campaign that they are doing. In this way all the orders in QlikSense will be tagged to a campaign if applicable to track marketing performance.
If u see the fourth record, it is a campaign for Malaysia where it applies to all product. Hence the composite Key (is Booking Week&Country&Product) will be blank for products in the case for Malaysia.
There are multiple permutations into it where there can be cases where country field are empty (which applicable all countries) and for certain product like bread.
Hence to list out all permutation in my QS code is not possible due to the complexity.
In my table , i added this code .
applymap('Test',Booking_Week & Country & Product ,false()) to get the campaign ID. How can i ask QS to smartly interpret those blank value and take in all the values? meaning for the case (Malaysia), it will take all products for Country = Malaysia.