topic Re: Join between union tables in QlikView

Join between union tables

Anonymous — Wed, 08 Aug 2018 18:52:33 GMT

I have 4 tables of sales per SKU, and only one with informations of these SKU (for example, description, supplier, cost...). The tables of "Sales" are united, and I need to join these united "Sales..." and the table "Info".

I was able to associate them, but in the dashboard, when I apply a filter with information from "Info" table, the graphic doesn't change.

Can someone please help me?

Re: Join between union tables

Anil_Babu_Samineni — Thu, 09 Aug 2018 00:04:57 GMT

Can you provide structure and expected structure?

Re: Join between union tables

Anonymous — Thu, 09 Aug 2018 14:55:57 GMT

Sure!

I have to add every week a table with information of the sales, so till the end of the year I'll have 56 tables of sales united. I have another table with detailed information of every SKU, and I have to join all these united tables to this one witch I called "CADASTRO".

The join seems fine, but when I insert a graph, for example, the values aren't showed properly. The info of "Store" is in the tables of "Vendas..." (or Sales in english), and the information of "Sales Type" and "Section" are in the table "CADASTRO" (where we have details of every SKU).

When I try to see the sales per store everything works fine, but when I try to see per sales type it brings me only the total. I think it's a problem on the join.

OBS: If I try to join only one table with sales information with the table "CADASTRO" then the information displayed is correct.