Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
2 Replies
sunny_talwar
MVP
MVP

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.