problem in last 12 months count

[#1]

Hi All,

          In my chart i have data for Dec 2010 to Jan 201 from i want show last 12 months servs count only. How can we do this for dates i have created a  calender using script...please see the attached file.

Regards,

Anil

[kaushiknsolanki]

HI,

     Have a look at the below post.

     http://community.qlik.com/message/187302#187302

Regards,

Kaushik Solanki

[SunilChauhan · Accepted solution]

convert you CalendarMonthAndYear  into

Jan-2011,

Feb-2011,

Mar-2011

;

;

;

and use below formula

count({<CalendarMonthAndYear ={">=$(=Date(addmonths(Max(CalendarMonthAndYear), -12), 'MMM-YY')) <=$(=Date(addmonths(Max(CalendarMonthAndYear), 0),  'MMM-YY'))"} >} C_SERV_REQ_ID)

hope this helps

[#4]

Thnx for your replies Sunil/Kaushik , Kaushik i dnt know much about set analysis so it is bit tricky to understand both posts any way i have tried Sunil's formula now its working fine thnx for your suggestions......

[#5]

Hi Sunil

           I want to add one more Dimension in the above Bar chart as a line, what is best chart for 2 dimensions

one dimension as Bar and second dimension as Line....Is combo chart is multiple dimension or multiple expressions?

Regards,

Anil