Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
dhasharadh
Creator III
Creator III

Accumulation not working as expected. Getting line chart for the future Order dates

Hi All, requirement is to show the Order executions in accumulation for the current month which is Jan 2022. But am getting extra dates greater than today. 

Dim :  Round(Order_Date - Monthend(Order_Date),1)

Exp 1 : Jan 2022 : 

Count({<  Churn_Date = {*} ,Order_Year_Month = { $(=Date(MonthStart(Today()),'YYYYMM')) } >} Source_Id)

Exp 2 : Dec 2021 : 

Count({<  Churn_Date = {*} ,Order_Year_Month = { $(=Date(MonthStart(Today(),-1),'YYYYMM')) } >} Source_Id)

Exp 3 : Jan 2021 : 

Count({<  Churn_Date = {*} ,Order_Year_Month = { $(=Date(MonthStart(Today(),-12),'YYYYMM')) } >} Source_Id)

 

Full accumulation, with step 6... if I Use full accumulation with no step then my 2022 Jan line is straight line till the end.

expectation is  (last loaded date) 9 - 31(monthend) = -21, current month line chart should stop here it self. but it is going till -14. Please help

@sunny_talwar @Anil_Babu_Samineni @jagan @marcus_sommer @Jonathan_Dienst @Clever_Anjos  

@Michael_Tarallo any other expert please provide the inputs.

attaching the sample data. 

Findings : when we only keep Jan 2022 expression, then x axis is limited to -20 only. and when we add all the expressions

 

dhasharadh_0-1641880270651.png

 

0 Replies