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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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