How to fill blank under specific condition

[beginnertom]

‌

Hi everyone,

I have a inline table for illustrate the model i want  as below,

Load * Inline[

Name, Brand,Country

Tom,Abc,Canda

Marry,TNT,China

Jerry,ANT,USA

Kitty,Abc,-

Betty,TNT,-];

If i want to set once the brand is Abc, the blank value in country field will automatically label as Canda(Kitty case). Brand is TNT, the blank value can be auto fill as China(Betty case)

Can i use any qlikvie script to acheive above purpose? Above inline is only a example, i want to use this technique to fill in my business model,

Thanks for everyone who can answer me. Tks!

[Miguel_Angel_Baeyens · Accepted solution]

If it's as "simple" as that, you can use ApplyMap() to return the country name based on the brand.

This function takes three parameters:

1. the first the mapping table (all possible combinations of country name and brand in this case)
2. the second the input parameter to look up to
3. the third the default value in case there is no match in the mapping table (i.e.: a brand with no country name in the data model)

[beginnertom]

Tks it. Work. And helpful!