Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Count claims for last 12 months ?

Hi All,

Please kindly assist me to get the count of distinct claims number for last 12 months-

I am not sure what to put in dimension field -

Currently it is looking like below-

clipboard_image_0.png

My req- 

clipboard_image_1.png

 

sample model attached.

1 Reply
Highlighted
Creator III
Creator III

Count(Distinct {<CLAIMS_CAPTURED_MONTH_NAME={">$(=max(CLAIMS_CAPTURED_MONTH_NAME)-100)"}>} [Claims Captured Claim Number])

 

However, I would use dates as date format not number as you are doing...