topic Re: Dates in QlikView

Dates

tomgrouwe — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Dates

avinashelite — Wed, 18 Oct 2017 09:56:20 GMT

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

Re: Dates

tomgrouwe — Wed, 18 Oct 2017 10:02:57 GMT

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