Concatinate with fact tables

[#1]

Hi. All

I need help.

I have fact table and some dimentions and a want to concatinate another indicators in fact table. My fact table have one of keys is date.

1. if a add indicators and date_key all good

2. but then a add 2 indicators without date_key a don't see this indicators

Who want help me

Thank you

[#2]

Can you attach the application.

[its_anandrjs]

Hi,

In this case the Key field is required when add to the fact table, if have a sample file then provide it.

Regards

Anand

[#4]

How i can upload my file. i don ' t see button

[#5]

In reply, click on "Use advanced editor" on the right top corner of reply. It'll take you to bigger reply option, there you can attach object option.

- Ed.

[#6]

i need add indicators with have dimentions: id_food, id_shop. But not id_date

[stevedark]

What is probably happening is when you load in the facts that don't have dates is that they are going into an associated table rather than concatenating.  You can either force a concatenation with the CONCATENATE statement, or add a dummy date field (i.e.  null() as id_date,).

You may then need to ignore some selections in some expressions - this can be done with Set Analysis - and you will find lots of information on this set of syntax on line.

You may also want to look at ApplyMap for where you have dimensions with a simple ID,Value pair.

Steve

[#8 · Accepted solution]

Use joins instead of concatenate and see, if this works for you.

Regards,

Ed.

[#9]

Ok. Its good helpfull for me. Thank you

May a know that you minght above paper Creating a Key/Link table in QlikView in book Qlikview for developer qookbook. AutoNumberHash256?

[#10]

For Autonumber you can refer to this post.

http://community.qlik.com/blogs/qlikviewdesignblog/2013/09/16/counters-in-the-load