topic Re: Create data island in backend in QlikView

Create data island in backend

prma7799 — Tue, 08 Aug 2017 10:49:49 GMT

Dear All,

I have one build application based on concatenate now i want to add three more tables in existing application and calendar also but i don't want to create any synthetic key or circular loop because in this new table have 90% same column as existing table.

Can anyone help me out?

Thanks...

Re: Create data island in backend

kaushiknsolanki — Tue, 08 Aug 2017 10:54:40 GMT

Hi,

Then you can concatenate those new 3 table to the existing one.

What is the problem?

Regards,

Kaushik Solanki

Re: Create data island in backend

prma7799 — Tue, 08 Aug 2017 11:03:06 GMT

Hi Kaushik,

Thanks for your quick reply.

Actually when i try to concatenate SalesInvoice and Shipment table in existing data model then getting some difference values.

Thanks

Re: Create data island in backend

kaushiknsolanki — Tue, 08 Aug 2017 11:08:53 GMT

Right you may not get it correct.

You need the link table, which will help you to connect them.

Concatenate vs Link Table

https://www.analyticsvidhya.com/blog/2014/12/remove-synthetic-key-concatenation-link-table-qlikview/

What is Link Tables? What is the use?

Regards,

Kaushik Solanki

Re: Create data island in backend

prma7799 — Tue, 08 Aug 2017 11:13:01 GMT

Hi Kaushik,

I got what was the problem...

I have already created the data island but due to case sensitive i am getting exact values ..

I have wrote like this

SUM({$<sl.DT={1}, sl.Order_Flag={'P'}>}SL.Sales)

Just corrected

SUM({$<SL.DT={1}, SL.Order_Flag={'P'}>}SL.Sales)

Thanks

Re: Create data island in backend

its_anandrjs — Tue, 08 Aug 2017 11:19:34 GMT

Hi,

You got it, but i suggested you can you please use composite keys or key field values while connecting two tables by left Joining or concatenate those tables depends on your result and out put by that tables.

Hope this helps

Regards

Anand