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

need help with duplicates showing in chart - I need to group and count

Hi all,

 Please make out that I need to learn how to group similar duplicates together as 1 value so that I can put them in a chart as 1 value. 

How to do this based on the fact that I also have a time and date on the side? 

For example 

sentence 1

sentence 1 is the same as sentence 1 but longer

how would combine sentence 1 and sentence 1 together?

2 Replies
ThePeterK
Creator
Creator

It depends on what you're trying to group by. You can leave the time out of the expression that you're using for the measure at really any level you want, and either do a distinct or aggr function to prepare the data for your viz.

93/93
Bubskim
Contributor II
Contributor II
Author

For example 

sentence 1

sentence 1 is the same as sentence 1 but longer

how would combine sentence 1 and sentence 1 together?