How to exclude one dimension values among multi dimensions in qliksense line chart

[SatyaPaleti]

Hi Everyone,

I have a requirement.

I have a Dimensions like Records and Measure as count of Records. Below is the screenshot for reference

for the 1st record it is 916 & 2nd record it is 295. 

Now one more dimension is adding which is called Date. Following report is generating when Date Dimension is Included

So My requirement is where ever there is 1st record it have to show 916  and when there is 2nd Record then value should be 295 only like in the below screenshot

I have used count(Total<Date> distinct record_id) but still it's not getting required output. Can some one please help me to resolve this issue

Thanks,

Satya

[stevejoyce · Accepted solution]

I believe you are looking to total by Records, so like this:

count(Total<Records> distinct record_id)

[SatyaPaleti]

Thank you Steve for your response. This is what I am expecting