Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
michaelcostner
Contributor II
Contributor II

Adding date field creates duplicate rows with null date values

Hey Everyone,

When I add a date or time field to my data set, each row is duplicated -- with one row having the correct date/time field and the other row having a blank date/time field. I've done some debugging myself buy cannot find why row ares duplicating. The raw data do NOT have any blank date/time values.

The screenshots below show what my data set looks like before and after adding the date/time fields. Unfortunately I cannot attach the QVW document as an example.

Has anybody come across this before or know of a solution?

Thanks in advance.

Michael

Prior to adding date/time

screenshot_1.png

After adding date/time

screenshot_2.png

3 Replies
Gysbert_Wassenaar

It looks like there's a value in Due Date rm that consists of an empty string or a string of spaces. Since I have no idea what data you're loading and how you do that I can't help you further.

Try to create an example that demonstrates the problem. Perhaps this document helps: Preparing examples for Upload - Reduction and Data Scrambling


talk is cheap, supply exceeds demand
vinieme12
Champion II
Champion II

Can you post a screenshot of your Data Model?

are you doing any Joins?

michaelcostner
Contributor II
Contributor II
Author

Thanks for the responses.

Here is a simplified qvw file. Hopefully it will explain the situation better.

Michael