Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
prma7799
Master III
Master III

Item code in one line

Hi All,

I have done something wrong in my data model please correct me .

PFA .

also find expected output excel.

Thanks

2 Replies
sunny_talwar

Would you be able to share  Margin.qvd and FACT_SalesInvoice_Transaction.qvd

micheledenardi
Specialist II
Specialist II

It seems that you have some records not defined on "FACT_ValueEntry" Table.

As you can see there are lots of "%VE_Key" without Item_Code.

2018-05-07 14_42_06-QlikView x64 - Copia del rivenditore - [C__Users_denardm1_Downloads_Cogs Test2.q.png

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.