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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
berndjaegle
Creator II
Creator II

Aggr for max date and count IDs

Hi guys,

I need a simple count but with the aggr function.

What I need: 

Last Date of an Import Run --> and Counting the items "LeistGUID" per MaxDate.

What works:  

Aggr( Max(Importdatum), LI_Quellsystem) --> gives me the max dates per Quellsystem.

and even showing the "LeistGUID" as a dimension.

Question:

How can I count the "LeistGUID" per  Max(Importdatum).

My try: 

count(Aggr( Max(Importdatum), LI_Quellsystem, LI_LeistGUID) )

Does count on all LI_LeistGUID, but count only on max is needed.

Qlik Sense_Aggr_LeistGUID.png

Thanks for you help.

BR,

Bernd

 

Labels (1)
0 Replies