topic Re: Issue in data model in QlikView

Issue in data model

sannidhikumar — Wed, 21 Dec 2016 05:37:13 GMT

Hi All,

PFA.

We have created 2 tables key is comman in 2 tables.(Key is composite key bu using resp fields in table).

But for some fields like

00610|LC|001410|2060

00620|LC|001410|2060

00670|LC|001410|2060

associated values are not showing though values are present in backend db.

Can you please suggest on this.

Thanks

Re: Issue in data model

Wed, 21 Dec 2016 06:11:41 GMT

In Your scenario i found you joined the both tables and filtered the data properly.

Relative values are getting shown others not shown when you go for selection.

Re: Issue in data model

sannidhikumar — Wed, 21 Dec 2016 06:20:49 GMT

hi ,

umamahesheswara any solution we can get .

thanks

Re: Issue in data model

sannidhikumar — Wed, 21 Dec 2016 12:00:24 GMT

Hello experts,

There are some problem with Key (On joining between the two tables).

Can you please suggest how shall i go ahead.

How should i join the two tables so that problem might be rectified.

Thanks

Re: Issue in data model

sannidhikumar — Thu, 22 Dec 2016 05:35:18 GMT

Hi All,

Can you please suggest how should i join the two tables.I am not able to get this.Can you please help me out.

Thanks

Re: Issue in data model

stabben23 — Thu, 22 Dec 2016 06:59:43 GMT

Hi,

in Your example there is no key from table AR_CustomerLedger, se pic.

Re: Issue in data model

avinashelite — Thu, 22 Dec 2016 07:03:05 GMT

You need share the data set ...requirements your trying to achieve and sample app then we could understand help you in sorting out the same

Re: Issue in data model

stabben23 — Thu, 22 Dec 2016 07:27:26 GMT

It also looks like you have different granularity in the 2 joined tables. This could lead to unexpected values in Your Charts. You need to find the lowest common keys to avoid this.

Maybe you should try to concatenate the tables instead.

Re: Issue in data model

sannidhikumar — Thu, 22 Dec 2016 07:29:30 GMT

Hi Staffman,

Thanks for the response .

Can you please suggest how would be the sequence of key as per granularity.

Thanks

Re: Issue in data model

stabben23 — Thu, 22 Dec 2016 07:54:56 GMT

Maybe you have find the lowest keys, i dont know. But in Your case it seams that you have one aggregated qvd (

AR_VarianceSummary_Custom.qvd) and one transaction table (AR_CustomerLedger.qvd). I should not join these, I should concatenate or maybe use a normal association between the tables With "key" as Your Associated key.

Re: Issue in data model

sannidhikumar — Thu, 22 Dec 2016 09:21:31 GMT

Hi Staffman,

You mean I need to use single key value rather than forming composite key.Moreover we tried to concatenate the two tables but it does not work.

Thanks

Re: Issue in data model

stabben23 — Thu, 22 Dec 2016 09:54:15 GMT

No, use compisite keys if you associate the data model, use Your Field key as you do in Your join, but without join part.

When you concatenate it will use all common keys when it concatenate. You can here remove the composite keys and instead use the Fields that is common. You shold also rename the Fields when concatenate so they have the same name in both tables. ex ARV_CO as CO, AR_CO as CO. But if Your not familliar With concatenate use Association.

Re: Issue in data model

sannidhikumar — Thu, 22 Dec 2016 10:00:14 GMT

Can you please share an example with me.

Thanks

Re: Issue in data model

stabben23 — Thu, 22 Dec 2016 10:08:02 GMT

start With this.