Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Dates

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.

1 Solution

Accepted Solutions
Highlighted

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

View solution in original post

2 Replies
Highlighted

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

View solution in original post

Highlighted
Contributor III
Contributor III

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