topic Re: map using in QlikView

map using

ali_hijazi — Thu, 23 Jan 2014 21:00:45 GMT

I got several fact tables concatenated together these tables share some columns and one of the shared columns is used as a flag to know each record to which fact or module it belongs to and there are columns

the data is something like this

A. B. flag. GroupCurrency

xx 4500 finance usd

yy 2500 finance aed

zzz 500 productivity

add 200 producticity

...

on the same sheet there are charts displaying figures related to different flags

however if user wants to filter by group currency the charts displaying info related to productivity will show nothing

so I thought I map all null fields to the value * using map using

does this affect performance or expressin results? Knowing that I will apply this on several columns as the fact table has about 15 columns that are not shared between modules (flags)

Re: map using

Carlos_Reyes — Thu, 23 Jan 2014 21:29:10 GMT

I don't follow your idea about using MAP USING...

Isn't it correct that charts displaying info related to productivity don't show data because these records don't have GroupCurrecy values?

Re: map using

ali_hijazi — Fri, 24 Jan 2014 04:59:41 GMT

yes but when I map null values to * and use Star is * they will display

Re: map using

Carlos_Reyes — Fri, 24 Jan 2014 13:38:41 GMT

Well, if that way you get the desired result it's ok. I just think that it may be misleading to show all types of records regardless that field selections, but I'm sure you already thought about that.

About performance issues? I don't see why using that method will create more performance issues than the number of records or the complexity of your expressions. In my experience 15 columns is not a big deal, you bettter optimize your expressions or reduce the amount of data if you get performance issues.