I am extremely new to Qlikview and is only able to produce some simple charts and tables.
But I run into a problem that, there are some data that is missing after I load from excel (xlsm file) to Qlikview.
I only have 5 Columns.
Year, Month, P&L, Product Type, Segment
I fully loaded all these columns onto there and tried to plot a line chart.
with Dimension of Month, against the Expression -- SUM of P&L
Surprisingly, I realise the total numbers shown on the line chart (where i point my cursor to) shows a total number of Dec (and other months too) does not match the total number of Dec (and other months too) on Excel.
After a long investigation, I see all across the months, it has only shown the SUM of P&L for three out of five of the Product Type
Any thoughts please?
I would love to share my file but its in the office...which I dont have access to now.