Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
cbaqir
Specialist
Specialist

Rolling Yearly Usage

I am trying to create a graph for NPrinting that shows Usage over the past rolling year.

The original expression is:

sum(aggr(sum({$}CNT_USAGE),DOMAIN,GOVERNING_CCG,DESCRIPTION,LAST_REVIEW_DATE))

This is what I was trying for rolling but it is not working:

sum(aggr(sum({$<TRX_DATE={">=$(=addmonths(monthend(today()),-12))<=$(=addmonths(monthend(today()),0))"}>}CNT_USAGE),DOMAIN,GOVERNING_CCG,DESCRIPTION,LAST_REVIEW_DATE))

or

sum({$<TRX_DATE={">=$(=addmonths(monthend(today()),-12))<=$(=addmonths(monthend(today()),0))"}>}CNT_USAGE)

1 Solution

Accepted Solutions
neelamsaroha157
Specialist II
Specialist II

sum({$<TRX_DATE={">=$(=Date(addmonths(monthend(today()),-12),'MM-DD-YYYY'))<=$(=Date(addmonths(monthend(today()),0),'MM-DD-YYYY'))"}>}CNT_USAGE)

Try this, its the date format which is different from your field format.

View solution in original post

2 Replies
cbaqir
Specialist
Specialist
Author

neelamsaroha157
Specialist II
Specialist II

sum({$<TRX_DATE={">=$(=Date(addmonths(monthend(today()),-12),'MM-DD-YYYY'))<=$(=Date(addmonths(monthend(today()),0),'MM-DD-YYYY'))"}>}CNT_USAGE)

Try this, its the date format which is different from your field format.

View solution in original post