topic problem in last 12 months count in QlikView

problem in last 12 months count

Wed, 01 Feb 2012 09:13:07 GMT

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

problem in last 12 months count

kaushiknsolanki — Wed, 01 Feb 2012 09:20:34 GMT

HI,

Have a look at the below post.

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

Regards,

Kaushik Solanki

problem in last 12 months count

SunilChauhan — Wed, 01 Feb 2012 09:21:21 GMT

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

problem in last 12 months count

Wed, 01 Feb 2012 10:07:24 GMT

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......

problem in last 12 months count

Wed, 01 Feb 2012 10:19:41 GMT

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