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: 
pranaligawde
Contributor III
Contributor III

Try to achive running count of ids for current month to last year same month

Hello All,

Try to achive running count of ids for current month to last year same month.but without restriction.Asi want to showfor current year month till previous year same month.But it should conider all the values before current month .bit it is considering from selected month only.

Dimension :MonthYear

Measure:

RangeSum(Above( total count({<period={">=$(prevyeardate)<=$(curryeardate)"}>} distinct Management_Escalations_Open_Cases_for_balance_CI)

,0,RowNo()))

 

12 Replies
pranaligawde
Contributor III
Contributor III
Author

Is there any clue on this??

kind help will  appreciate.

tresesco
MVP
MVP

If you are using latest (Feb 2020 or later) version of qs, you could use chart's 'Accumulation' feature under 'Modifier' settings.

Capture.PNG 

pranaligawde
Contributor III
Contributor III
Author

Yes,i could use but i also need to restrict month .and it should accumulated from last year current month -11 months till today.

tresesco
MVP
MVP

You can set that step too.

Range ->Custom, Step ->11

pranaligawde
Contributor III
Contributor III
Author

Yes ,i did that but it's  not showing any change.

pranaligawde
Contributor III
Contributor III
Author

Kindly check this attached

 

tresesco
MVP
MVP

Could you share your sample app?

pranaligawde
Contributor III
Contributor III
Author

hello @tresesco ,

 

As requested,attached is the sample data qvf.

tresesco
MVP
MVP

I can see that values are accumulating without any selection. Can you explain your exact requirement (perhaps w.r.t. selection behavior) ?