Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
prma7799
Master III
Master III
‎2017-05-05 02:45 AM

Getting double records

Dear All,

I don't understand why i am getting double records for shipment No fields .. all shipment no getting double records here.

I am just giving one record sample

Can you please look into here.

Thanks

Double Entries1.qvw
733 Views
0 Likes
4 Replies
Anil_Babu_Samineni
MVP
MVP
‎2017-05-05 03:05 AM

Check the Suppress when value is null for ShipmentNo

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
600 Views
0 Likes
qlikview979
Specialist
Specialist
‎2017-05-05 03:20 AM

Hi

find the attached file

Double Entries1.qvw
600 Views
0 Likes
jackhertel
Contributor III
Contributor III
‎2017-05-05 03:23 AM

Can you upload your QVDs?

I am assuming when you are joining the two tables is where you are doubling the data.

Thanks

600 Views
0 Likes
qlikview979
Specialist
Specialist
‎2017-05-05 04:09 AM

may be this

click on first dimention(Customer_Code) --->click on Edit

write the condition like this

=if(len(Customer_Code)>0,Customer_Code)

600 Views
0 Likes