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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
MassicotPSCU
Contributor III
Contributor III

Duplicate rows for the same day (Concatenation)

Hi,

I have concatenated two tables together. One with sales and one with sales per hour. The records are of these sales and sales per hour are day to day. My issue is that I have duplicate days now, one for sales and one for sales per hour. I would like to have just one row worth of data for each day. Is there a fix for this or is that how Qlik Sense just does things?

MassicotPSCU_0-1682085652989.png

 

Labels (4)
1 Reply
sandeep-singh
Creator II
Creator II

I would say use applymap function instead of the Concatenation. Below is the qlik community post for your reference.

https://community.qlik.com/t5/Design/Don-t-join-use-Applymap-instead/ba-p/1467592