Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

doubt to join two tables

Good Day!
Gentlemen,
I'm entering the world of qlick view now and I have some doubts.

I know that for some doubts are simple, however if they can help me be grateful.

I have two tables.

For example:

Table A:

Brand | Model | Value
22,000 Fiat Palio
Ford Fiesta 25,000
Fiat Palio -1200
Ford Fiesta -3520


Table B:
Brand | Source | Model | Year
2000 Ford Fiesta Americana
American Fiat Palio 2008
American GM Vectra 2010


I would like to join the tables, where the new structure would be as follows:

Brand | Source | Model | Year | Value Positive | Negative Value
American Fiat Palio 2008 22000 -1200
Ford Fiesta Americana 2000 25000 -3250
American GM Vectra 2010 0 0


If someone can get me an e-mail sent in Excel tables.

OBS.: How not to speak English using Google Translate. To get a better view of the table I created is better to translate from english to Portuguese, at least the tables.

I thank for your attention.

Jorge Rodrigues
jorge.rodrigues @ meltex.com.br

2 Replies
alfasierra
Contributor II

doubt to join two tables

qlik join the tabel using the name of fields , so your table are already join by fields Brand and Model

Not applicable

doubt to join two tables

Alfasierra,
Already got an example right here in the community that I think will help me.
I'll see if I put a clearer example of what I want.

Community Browser