Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
DamienSer
Contributor
Contributor

Last 6 month without current month

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 !

Labels (2)
1 Reply
dplr-rn
Partner - Master III
Partner - Master III

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)