Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rolling 12 Month backwards

Hello,

In my expression, i am adding this code,

Count({$<[Cause Code]={'Access Issue'},InciMonth = {">=$(=Month(MonthStart(Max(Approved))-365))<=$(=Month(MonthEnd(Max(Approved))-1))"},InciYear=,InciMonth=>}[Task])

Here i am counting the Task with the Cause Code ='Access Issue'.

Approved is the Date column . InciYear & InciMonth is the Year & Month Respectively.

The values i am getting correctly, but the x-axis is not changing based on my month selection. Can you please help me out.

Thanks,

Sasikumar.R

0 Replies