topic Re: Assuring all records with no allocation are not null in QlikView

Assuring all records with no allocation are not null

Mon, 25 May 2015 08:49:33 GMT

Hi All,

A simple question, I just don't know technical wording to do a proper search on this forum, as I am sure solution already exists..

So in my simple words.

I have a data table (first Inline in my attachment). I need to add one more dimension, containing market name. it is a rule that each account can cover only one market code, and most of them do cover a domestic market code (let's say that the domestic is Spain).

Problem: I would like to see Spain for all those records that are missing in my 2nd Inline load of attached report. That way, in my 2nd Inline, I limit the data only to those with other than Spain market names.

Thanks a lot for your help

Re: Assuring all records with no allocation are not null

Gysbert_Wassenaar — Mon, 25 May 2015 09:16:42 GMT

You can use a mapping table and the applymap function. See attached example.

Re: Assuring all records with no allocation are not null

Sat, 30 May 2015 20:30:05 GMT

Hi Gysbert Wassenaar,

I was tryin to apply your logic to the conditions being closer to the report I am trying to build - have a look in the attachment.

I can not get "Spain" in all empty rows - what am I doing wrong//??

Thanks a lot for your help.

Draszor

Re: Assuring all records with no allocation are not null

Sat, 30 May 2015 20:32:37 GMT

I attach the files - may !be this time they o through

Re: Assuring all records with no allocation are not null

stabben23 — Sat, 30 May 2015 21:43:44 GMT

Hi,

v_Account is not know in your applymap, use ApplyMap('MapMarket',Left(Account,3), 'Spain') as MarketCode, instead