topic Re: missing link and values when joining 2 tables in QlikView

missing link and values when joining 2 tables

Anonymous — Tue, 24 May 2016 11:16:29 GMT

I am trying to arrive at a dynamic report solution where there are multiple fields that can be selected and results displayed in the dynamic report window. i have attached a screenshot.

we are having 2 tables one with plan and other with actuals.

in the attached screenshot, we are trying to combine this plan and actual to display the values for one of the customers. but the plan and actuals comes up in separate line since the sales group is not a field present in the plan. but the actual table has both the sales group and sales group historical.

is there any ways to copy the sales group value to the line where you could see NULL value. indicated in red.

i understand peek is one such option but because of the complexity of load and multiple concatenates with data from various tables, i find this hard to set the value

any thoughts?

Re: missing link and values when joining 2 tables

PrashantSangle — Tue, 24 May 2016 12:17:35 GMT

Hi,

can you tell us which are dimensions and which are expressions??

Regards

Re: missing link and values when joining 2 tables

perumal_41 — Tue, 24 May 2016 12:21:03 GMT

Hi Krishna,

which filed linking two table Plan and actual . if customer filed, then keep same name in both table

Re: missing link and values when joining 2 tables

Anonymous — Tue, 24 May 2016 20:49:24 GMT

i have attached my selections which indicates the dims and measures.

Re: missing link and values when joining 2 tables

Anonymous — Tue, 24 May 2016 23:16:45 GMT

Hi Perumal , can you please elaborate, i can try making changes.

Re: missing link and values when joining 2 tables

PrashantSangle — Wed, 25 May 2016 05:26:34 GMT

Hi,

try

> only move your Customer Group Historical field from dimension to expression.

> only move your Customer Hierarchy field from dimension to expression.

Regards,