Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Vasiliy_Beshentsev
Creator III
Creator III

How to keep data in 1 row?

Good day, everyone!

I have a problem with keeping data in 1 row.

So here is example what i want to achieve:

2018-09-28 12_47_49-Qlik Sense Desktop.png

I load data from 2 different sql servers and some order are keep data in 1 row but sometimes it's not, and put it in 2 rows:

2018-09-28 12_43_47-Qlik Sense Desktop.png

Any suggestion for help?

1 Solution

Accepted Solutions
Vasiliy_Beshentsev
Creator III
Creator III
Author

I have found my mistake in data and now everything is great!

View solution in original post

3 Replies
timpoismans
Specialist
Specialist

If the first field is the key between data from server1 and data from server2, try a left join.

Though without much knowledge of your data model, it's quite hard to give you a suggestion that might solve your issue.

Vasiliy_Beshentsev
Creator III
Creator III
Author

Yea, first field is the key.

It's now work for me, i'm trying this already.

It's very strange that some orders a ok but some others are not, and i don't understand why

Vasiliy_Beshentsev
Creator III
Creator III
Author

I have found my mistake in data and now everything is great!

View solution in original post