I made a calender with a fixed start and end date. Qlikview makes al the dates in between. This worked perfectly for my dashboard untill now. I need to add a detailed overview (orderlines) from the sourcedocument (XLS). Because Qlikview makes all the dates, i have a lot of lines that only contain a date, but no data. How can i solve this? I only want to show the lines that actually contain data.
to achieve this in the table box , you need a new date field in TrackTraceData table like this and use that date in the table box and rename the field as Date
TrackTraceData:
LOAD Loadnumber,
ULM,
[Country of destination] AS CountyDest,
[Zipcode of destination] AS ZipDest,
[No. Pallets] As NoPall,
[Loading date] AS LoadDate,
[Unloading date] AS UnloadDate,
[Actual loading date] As Date,
[Actual loading date] As Track_Date
[Actual unloading date] AS AcUnloadDate,
//[A carrier] AS ACarrier,
//[Check carrier] AS CCarrier,
//[Executive carrier] AS ECarrier,
Damages,
Remark,
[Loading performance] AS LoadPerf,
[Delivery performance] AS DelPerf,
Timestamp_Load,
Timestamp_Actualdate
use Track_Date in your table box that will solve the issue
to achieve this in the table box , you need a new date field in TrackTraceData table like this and use that date in the table box and rename the field as Date
TrackTraceData:
LOAD Loadnumber,
ULM,
[Country of destination] AS CountyDest,
[Zipcode of destination] AS ZipDest,
[No. Pallets] As NoPall,
[Loading date] AS LoadDate,
[Unloading date] AS UnloadDate,
[Actual loading date] As Date,
[Actual loading date] As Track_Date
[Actual unloading date] AS AcUnloadDate,
//[A carrier] AS ACarrier,
//[Check carrier] AS CCarrier,
//[Executive carrier] AS ECarrier,
Damages,
Remark,
[Loading performance] AS LoadPerf,
[Delivery performance] AS DelPerf,
Timestamp_Load,
Timestamp_Actualdate
use Track_Date in your table box that will solve the issue
