topic Re: Data Problem in QlikView

Data Problem

sannidhikumar — Mon, 27 Mar 2017 12:36:59 GMT

Hi All ,

after removing synthetic keys the data is not matching properly .

any suggestions ,

thanks ,

Re: Data Problem

m_woolf — Mon, 27 Mar 2017 14:10:30 GMT

Would have to see the data and the data model to comment.

Re: Data Problem

jonas_rezende — Mon, 27 Mar 2017 18:25:21 GMT

Hi, pradeep kumar.

Please, share qvw with us.

Regards,

Jonas Melo.

Re: Data Problem

sannidhikumar — Tue, 28 Mar 2017 05:23:20 GMT

Re: Data Problem

aapurva09 — Tue, 28 Mar 2017 05:31:28 GMT

Hi,

You need to make sure the right keys are used for connection. Here in the screenshot it can be seen there are date related fields that are common. If you want your connection to include the date fields, they should be added in your 'Key' field.

Thanks

Re: Data Problem

sannidhikumar — Tue, 28 Mar 2017 05:33:35 GMT

Apurva ,

i already concatenated but the data is getting wrong any other solutions .

thanks ,

Re: Data Problem

aapurva09 — Tue, 28 Mar 2017 05:52:52 GMT

Can you share how you concatenated the fields to make 'Key' field?

Re: Data Problem

sannidhikumar — Tue, 28 Mar 2017 06:01:05 GMT

after concatenated i got this result .

Re: Data Problem

sannidhikumar — Tue, 28 Mar 2017 07:41:13 GMT

Apurva ,

i used concatenate fact table then at last i got this result . you can check the above synthetic keys Data Module.

thanks ,

Re: Data Problem

sannidhikumar — Tue, 28 Mar 2017 12:48:10 GMT

hi All ,

any one there to reply to this query .

thanks ,