topic Correct Description for an Item in QlikView

Correct Description for an Item

Wed, 31 Jul 2013 10:12:17 GMT

We have a Head Office in Johannesburg with a few branches which operates independently. When items are loaded, the description varies for the same item for the branches.

How do I create a formula to always show Head Office 's description. If an item does not exist in Head Office , then it should take the description of the branch.

In the table below, the solution i am looking for is in the last column - "Correct Description".

So, for eg, item code "B" , the correct descrition should be Banana's , which is the same as Head Office Description. For Item code "C", because Head Office does not have the item, it must take the description of Port Elizabeth, which is "Carrot".

Branch Name	Item Code	Description	Correct Description

Durban	B	Banana	Banana's
Head Office	B	Banana's	Banana's
Cape Town	B	Bananas (Pack)	Banana's

Port Elizabeth	C	Carrot	Carrot

Durban	P	Pear	Pear

Head Office	A	Apple's	Apple's
Port Elizabeth	A	Apples (10)	Apple's
Cape Town	A	Apples (Pack)	Apple's
Durban	A	Apple	Apple's

Please help

regards

Nayan

Re: Correct Description for an Item

marcus_sommer — Wed, 31 Jul 2013 11:12:19 GMT

This could be solved with:

mapping ( load-befehl |select-befehl )

Mapping1:

MAPPING LOAD * INLINE [
x,y
US,USA
U.S.,USA
America,USA
Amerika,USA];

- Marcus

Re: Correct Description for an Item

Wed, 31 Jul 2013 14:47:04 GMT

Hi Marcus

Thanks. Will try it out.

Will this formula apply to many items. Because in my actual Qlikview Model, I have over 10 000 items like these.

kind regards

Nayan

Re: Correct Description for an Item

marcus_sommer — Wed, 31 Jul 2013 15:09:16 GMT

Yes it will, no problem. You will need time these values to match (manually?) for mapping-table ...

- Marcus