Discussion board where members can get started with QlikView.
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
qlik join the tabel using the name of fields , so your table are already join by fields Brand and Model
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.