Last 6 month without current month

DamienSer — Sat, 16 Nov 2024 04:32:43 GMT

Hello,

I trying to create a function in order to have the count of Incident for the last 6 month without currect mont.

I've created both Measure because I've a chart with two bars :

=Count({<CI_APPLI_INFRA={'Infrastructure'}>}CI_APPLI_INFRA) + Sum({1} 0)
=Count({<CI_APPLI_INFRA={'Application'}>}CI_APPLI_INFRA) + Sum({1} 0)

On dimension case I've added that : "MonthYears".

Do you know how can I do that ?

I think I've to add one more thing on my both measures.

Many thanks for your help !

Re: Last 6 month without current month

dplr-rn — Wed, 06 Feb 2019 19:05:40 GMT

Need more information on your date field to help properly but on a high You need to use set analysis to get data before current month and after a point of time in 6 months

something like below

OrderDate={"<=$(=EXPRESSIONFORENDDATE) >=$(=EXPRESSIONFORENDDATE)"}

e.g. Sum( {<OrderDate={">=$(=AddMonths(Max(OrderDate),-6)) <=$(=Max(OrderDate))"}>} OrderRecordCounter)

topic Last 6 month without current month in QlikView

Last 6 month without current month

Re: Last 6 month without current month