QlikSense

[Anonymous]

I have a distinct count of records. When i include a second dimension(status), the distinct count includes the same record for 2 different status as 2 records(i would only like to consider it once, with the latest updated status).

Please can anyone help with the calculation.

Thanks

[Anonymous]

yes

[OmarBenSalem]

Is this ok?

Check the attached App

[Anonymous]

Yeah this is how i want the bar to be stacked with the status and distinct count.

What have you used in  the measure field?

[OmarBenSalem]

=Aggr( max(DateStatus),[Order No])

Check the attached App, you'll find out.

If you don't understand a thing, don't hesitate to 'call back'.

And don't forget to close the thread if your quetsion has been answered

Have a nice weekend

[Anonymous · Accepted solution]

Hi,

Thanks a ton for your help.

There seems to be some error when i tried this approach you suggested.

I tried for some more and this below formula worked for me

Count(If(Aggr(NODISTINCT Max(Date), [Order No]) = Date, [Order No]))  as the measure formula