topic Re: How can i build a table from two separate tables ? in QlikView

How can i build a table from two separate tables ?

marieclaire — Mon, 28 Sep 2015 22:24:43 GMT

Hello,

I try to build a model and i would need some help :

I have files of audiences (in the attached file, one table of visitors) with a key on the Sites.

And a file which describes the sites (refrentiel).

I made a left join between them.

Question about the model :

I would like to build a device table following this :

> the field"device" of the file "referentiel" works for the apps (type=app)

> i will have special files for the type "site".

cf "device_web_InfoRegion_201508"

How can i build the model ?

I must create a third table "Device_all"?

Question about the "sub-total"

I make a "total by marque" :

sum(TOTAL<marque> (Visiteurs_Uniques_tous))

But this total is repeated on each row of the marque.

Is it possible to display the "Total Vr par parque" only once, as a subtotal ?

Thank you for your help.

Re: How can i build a table from two separate tables ?

malini_qlikview — Tue, 29 Sep 2015 10:21:46 GMT

Hi,

1. Load data for type =(app and site) in one table (this may be from multiple source csv/txt etc). Flag a column to identify if the loaded data is for app/Site

2. Link the table with the unique key (@CLE_Site and Type)

Re: How can i build a table from two separate tables ?

marieclaire — Fri, 02 Oct 2015 12:11:29 GMT

Hi,

As a Qlikview beginner, i needed to know more about the syntax.

I finally found help from a developper who showed me sql instructions.

A join between 2 tables + where Type="app" + union on a table of reference.

Thank you Malini.

Christiane