Discussion Board for collaboration related to Creating Analytics for QlikView.
what I'm looking for is to create a field in Qlikview like what I've done in Excel.
I thought it would be simple to replicate, but it's not to me.
Here is my excel attached with my formula in the "L" column of "DB_Fatt" sheet.
Thank u so much.
(ooxml, embedded labels, table is DB_Inc)
Group By CUSTOMER_TRX_ID;
(ooxml, embedded labels, table is DB_Fatt)
ImportoIncassi as ImportoIncassi_OLD,
Alt((ApplyMap('MappingTable', CUSTOMER_TRX_ID, 0) * INV_DIST_BASE_AMOUNT)/ApplyMap('MappingTable2', CUSTOMER_TRX_ID, 0), 0) as ImportoIncassi_NEW
(ooxml, embedded labels, table is DB_Fatt);
View solution in original post
Don't see any attachment. Can you reattach?
"Here is my excel attached w" nothing attached
Damn! I don't know why it was not uploaded before ...