Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
prma7799
Master III
Master III

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

4 Replies
Anil_Babu_Samineni

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
qlikview979
Specialist
Specialist

Hi

find the attached file

jackhertel
Contributor III
Contributor III

Can you upload your QVDs?

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

Thanks

qlikview979
Specialist
Specialist

may be this

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

write the condition like this

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