Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

QlikSense

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

14 Replies
Anonymous
Not applicable
Author

yes

OmarBenSalem

Is this ok?

Capture.PNG

Check the attached App

Anonymous
Not applicable
Author

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
Not applicable
Author

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