topic Re: Data not Mapped Properly in QlikView

Data not Mapped Properly

Thu, 27 Aug 2015 05:07:30 GMT

HI All,

Please find the attached data model. There is some issue with my model. I have mentioned the details in the QVW.

Some columns are not mapped so the values are zero for it.

Please help me where the mistake might have happened.

Let me know if you need any other details.

Regards,

Keerthi KS

Re: Data not Mapped Properly

stabben23 — Thu, 27 Aug 2015 06:03:03 GMT

Hi,

the field S_Status is from your Salestable and can not be used in the straight table as a dimension, the Straight table is shown correct. S_status will only present data that is from your Sales table.

Re: Data not Mapped Properly

Thu, 27 Aug 2015 06:09:09 GMT

HI Staffan,

what should i do if i need to show data for S_Status ?

Sales table is linked to Receivables through S_ID(Saleorder)

Regards,

Keerthi KS

Re: Data not Mapped Properly

stabben23 — Thu, 27 Aug 2015 06:58:54 GMT

Hi,

When you use Left join in models it is important that you have a 1 to 1 relation, oterwise you will have problem when you aggregate in for ex straight tables. Maybe you need to use composite key. Your script is a little bit "messy", it will take a lot of time to figure out what can be changed here. Make some tablebox to find out what relations you have between field and values.