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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
amba1
Contributor III
Contributor III

Distinct Strings grouped by day!

Hi there,

I have a file that looks like this

DATE;CODE

31.08.2021;XX

31.08.2021:XY

31.08.2021;XX

31.08.2021;A*B*

31.08.2021;A*B*

31.08.2021;XX

01.09.2021;XX

01.09.2021;XX

01.09.2021;XX

There's:

  • 3 x XX
  • 2 x A*B*
  • 1 x

I want to select the distinct codes grouped by day. My output file would then be

DATE;CODE;COUNT

31.08.2021;XX;1

31.08.2021;A*B*;1

31.08.2021;XY;1

01.09:.2021;XX;1

I use a tAggregateRow to sum the count and group them by day. But how do I sum the distincts only?

I know I can just select distinct and count them with an aggregaterow, but I want to output them as well

Labels (3)
1 Reply
amba1
Contributor III
Contributor III
Author

This was pretty easy to do with the tuniqrow component.

 

File > tuniqurow on code > tmap > taggregaterow to count and done 🙂