topic Re: How to fill blank under specific condition in QlikView

How to fill blank under specific condition

beginnertom — Wed, 25 Nov 2020 16:16:04 GMT

‌

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!

Re: How to fill blank under specific condition

Miguel_Angel_Baeyens — Tue, 22 May 2018 15:46:59 GMT

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:

the first the mapping table (all possible combinations of country name and brand in this case)
the second the input parameter to look up to
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)

Re: How to fill blank under specific condition

beginnertom — Sun, 03 Jun 2018 13:23:03 GMT

Tks it. Work. And helpful!