topic Re: Concatinate with fact tables in QlikView

Concatinate with fact tables

Sat, 22 Nov 2014 19:31:59 GMT

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

Re: Concatinate with fact tables

Sat, 22 Nov 2014 20:01:55 GMT

Can you attach the application.

Re: Concatinate with fact tables

its_anandrjs — Sat, 22 Nov 2014 20:14:36 GMT

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

Re: Concatinate with fact tables

Sat, 22 Nov 2014 21:20:41 GMT

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

Re: Concatinate with fact tables

Sat, 22 Nov 2014 21:30:49 GMT

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.

Re: Concatinate with fact tables

Sat, 22 Nov 2014 21:34:49 GMT

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

Re: Concatinate with fact tables

stevedark — Sat, 22 Nov 2014 22:07:40 GMT

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

Re: Re: Concatinate with fact tables

Sat, 22 Nov 2014 22:13:53 GMT

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

Regards,

Ed.

Re: Concatinate with fact tables

Sat, 22 Nov 2014 22:20:26 GMT

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?

Re: Concatinate with fact tables

Sat, 22 Nov 2014 22:27:22 GMT

For Autonumber you can refer to this post.

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