topic Re: Map a dimension for multiple scenarios in QlikView

Map a dimension for multiple scenarios

arusiva89 — Fri, 13 Aug 2021 03:23:45 GMT

I need to write a logic in the load script for the below scenario. Could you please suggest the best way to achieve that

I need to map the keyword for the respective code in the QVD based on the below condition.I have multiple scenarios to check like if the letter is greater than 2000 and the Author does not equal or equals to a specific name. I have tried with mapping load but I ended with multiple mapping tables

My QVD has Code, Letter & Author

Mapping sheet

Code Letter Author Keyword

A 2500 QQ Ok

A 1500 BB SS

B 1800 CC VV

B 2800 QQ Ok

Re: Map a dimension for multiple scenarios

MayilVahanan — Fri, 13 Aug 2021 05:16:00 GMT

You can try with nested if condition something like below

If(Letter > 2500 and Author= 'QQ', 'OK', If(Author = 'BB', 'SS', 'VV')) as Keyword

Re: Map a dimension for multiple scenarios

Brian2569 — Sat, 14 Aug 2021 04:29:55 GMT

Multi-dimension mapping enables you to define member mapping based on multiple source column values. This functionality provides you with the ability to load data into dimensions unavailable in the target application. For example, the mapping for Account dimension can be based on source values of Entity, Product, and Project. Multi-dimension mappings derive the target values based on the combination of source values. In addition, Lookup dimensions can be added to Target Application registration. These dimensions contain source dimensions that do not exist in the target application. They provide even more flexibility in creating multi-dimension filters. It is a way to facilitate conditional data loading. One Vanilla

Re: Map a dimension for multiple scenarios

arusiva89 — Fri, 13 Aug 2021 16:23:03 GMT

I have around 500 code to map.I have given few for example

Re: Map a dimension for multiple scenarios

arusiva89 — Fri, 13 Aug 2021 16:23:04 GMT

Do you mean any extension?

Re: Map a dimension for multiple scenarios

arusiva89 — Fri, 20 Aug 2021 18:04:40 GMT

I have attached some sample here.My actually list is very huge

Re: Map a dimension for multiple scenarios

arusiva89 — Fri, 20 Aug 2021 18:05:05 GMT

Do you mean any extension?