Data Model issue?

[khadeer]

Hi all,

I have created a data model based on invoice number. But when i am showing the data in manager level or region level my data model is not supportung. Please help me how to change my data model?

Regards,

Khadeer

[kamalqlik]

Hi Friend,

This may be because masters may be not linked properly with the transaction table.

Can you give the overview of table.

Keep in mind that when you are approaching for a data model your table shold be linked properly.

Otherwise you will failed to get the desired result.

I am attaching the PDF for working with data model in qlikview.

Hope it helps.

Regards

Kamal

[khadeer]

Hi Kamal,

Thanks for ur reply,

I am fetching the data from SAP reports, I have 5 reports(Transactions), I linked these tables by making KEY, and i have 4 masters and i have give association to those masters.

Regards,

Khadeer

[sujeetsingh]

Why not you post a sample file and yes try joins for proper association if possible.