topic Syncronized Table in QlikView

Syncronized Table

danialier — Mon, 13 Jan 2014 11:06:22 GMT

Hello,

I have two excel files to be uploaded in a new QV document. These two file contain:

1. Revenue data: three dimensions for Country (Brazil, ...) , Period (January, ...) and Revenues (dollars)

2. Market share: three dimensions for Country (Brazil, ...), Period (January, ...) and Share (%)

I want to upload these two two tables and afterwards be able to select a country for an specific period and to get revenue and share data. However when I upload these two tables, I get a "$Syn 1 Tabe" (see ppt attached)... How can I avoid this ?

Please help !

dani

Re: Syncronized Table

Anonymous — Mon, 13 Jan 2014 11:23:16 GMT

$Syn 1is not an error,

After loading the data you can create a chart , containing Country and Period as dimension and

sum(Revenue) and sum(Share) as Expressions.

The data shown will be correct.

However if you want to ignore syn ke,

then create conposite key of Country and period as follows:

Tab1:

Load Country&'-'&Period as #Key,

Country as Country_Revenue,

Period as Period_Revenue,

Revenue

from Table 1;

Tab2:

Load Country&'-'&Period as #Key,

Country as Country_Share,

Period as Period_Share,

Revenue

from Table 2;

Now when you will load data there will be no syn key,

Instead both tables will be mapped through #key.

Hope this helps.

Regards

Nitin

Re: Syncronized Table

danialier — Mon, 13 Jan 2014 12:47:53 GMT

thanks !