Dates

[tomgrouwe]

Dear experts,

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.

[avinashelite · Accepted solution]

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

[tomgrouwe]

Wow, that simple haha. Nevertheless thank you very much.