topic Re: ApplyMap in QlikView

ApplyMap

NavinReddy — Mon, 22 Apr 2013 11:49:19 GMT

Hi All,

I have Two tables one is FACT table haveing 120 million records,second is Dimention table having some records

i need to be use Dimentions Table Fields in Fact table

What is the best way Plz tell

Thanks in Advance

Niranjan

hic — Tue, 23 Apr 2013 12:03:43 GMT

Load the dimension field as a mapping table and then use ApplyMap. See more on

HIC

NavinReddy — Tue, 23 Apr 2013 13:04:59 GMT

Hi Henric,

Could you plz tell me,what the about datamodel ,

How could i design in table viewer

Thanks

Niranjan

hic — Tue, 23 Apr 2013 13:13:19 GMT

You need to make the changes in the script, according to the following:

MapDimensionField:

Mapping Load DimensionID, DimensionValue From Dimension ;

Facts:

Load *,

ApplyMap('MapDimensionField', DimensionID, null()) as DimensionValue

From Facts ;

HIC

vikasmahajan — Tue, 23 Apr 2013 13:21:47 GMT

Henric Sir,

Can I use appy map function to calculate customer wise oustanding ?

Please reply

Thanks

Vikas

NavinReddy — Tue, 23 Apr 2013 15:19:38 GMT

Hi Henric,

Thanks a lot really its help full for me & other

Thanks

Niranjan