topic Re: Count records with max date (over ID) in QlikView

Count records with max date (over ID)

Anonymous — Wed, 08 Aug 2018 09:39:33 GMT

Hello everyone,

I have the following data:

The task is to draw the chart with date dimension and expression like:

Count(DISTINCT {%DateType={'Special'}>} ID). But need to display only max(date) for ID.

So, desired result:

How can i achieve this?

tnx in advance.

mtucholski — Wed, 08 Aug 2018 09:53:31 GMT

Hello, try this calculated dimension:

aggr(max({<DataType={Special}>} Date),ID)

mtucholski — Wed, 08 Aug 2018 09:58:05 GMT

Sorry, it should be like that:

=if(DataType='Special',aggr(max({<DataType={Special}>} Date),ID),Null())

and suppress null values.

sunny_talwar — Wed, 08 Aug 2018 11:33:20 GMT

Have you tried using Max(Date) where %DataType is Special as your expression?

Date(Max({%DateType={'Special'}>} Date)