topic create count over 12 months from the date in QlikView

create count over 12 months from the date

Tue, 27 Aug 2013 15:42:29 GMT

Hi The community,

I don't understand mistake.

I want to create a graphiq with this expression :

= COUNT({$<Date={">=$(=MonthStart(AddMonths(Max(MoisDateCreationOT),-12)))"}*{"<$(=MonthEnd(Max(MoisDateCreationOT)))"}>}ID_OT)))

but screen displays anything

I want to display ID_OT by month and more precisely over 12 months from the date

How can I do?

Thanks a lot

jagan — Tue, 27 Aug 2013 15:48:23 GMT

Hi,

Try like this

= COUNT({$<Date={">=$(=MonthStart(Max(MoisDateCreationOT),-12))<$(=MonthEnd(Max(MoisDateCreationOT)))"}>}ID_OT)

Hope this helps you.

Regards,

Jagan.

Gysbert_Wassenaar — Tue, 27 Aug 2013 15:51:28 GMT

1. Try

COUNT({$<Date={">=$(=MonthStart(AddMonths(Max(MoisDateCreationOT),-12)))<$(=MonthEnd(Max(MoisDateCreationOT)))"}>}ID_OT)))

2. If you want to use month as dimension and show the count as a rolling count over 12 month you can't use set analysis. You can try using an AsOf table. See this document for more information: Calculating rolling n-period totals, averages or other aggregations