Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
paullawrence190
Contributor
Contributor

Rolling 12 months using flag but only want to show YTD

Hi all

 I am trying to create a YOY comparison chart in qlik showing a rolling 12 month average,  I have set up rolling 12 month flag but when I use it I get all months filled in and cant limit to that financial year in the set as restricts the rolling 12 months:

=Num((Count({<[Client]={'Fred'},Post={'Full Duties'},[Disch ind]={'Y'},R24M_Flag={'1'},R12M_Flag={'0'},>}[patid]))

/

(Count({<[Client]={'Fred'},[Disch ind]={'Y'},PTSFLAG={'0'},FiscalYear=,R12M_Flag={'0'},R24M_Flag={'1'},}[patid])),'##0.0%')

 I have put a picture below on what I am trying to achieve.

 

Any help would be appreciated.

 

Many thanks

 

Paul

 

1 Reply
sunny_talwar

Would you be able to share a sample to see what you have to help you better?