Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Rolling 12 months 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

Community Browser