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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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

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.