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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Mini_Elaine
Contributor III
Contributor III

Cumulative line chart without filter impact

Hi experts,

I am trying to create cumulative line charts with accumulation function of my measure. This chart should not be impact by one of filters. Please see below example:

 

Mini_Elaine_0-1700491047983.png

This chart above to show cumulative product ordered each financial month by financial year.  I actually have two master calendars for financial year: master calendar for ordering date and one for shipping date. I would like to navigate different financial year for shipping date but not impact the chart above. Then I put set analysis in my measure as:

Sum({<[FinYear_shipping]= >}[product_count])

 

However, I found the chart still reflect to filter selection of shipping financial year if I apply accumulation for my measure. But it works perfect with actual measure for each financial month. How do I apply cumulative measure without filter impact?

Many thanks! 

Labels (4)
1 Solution

Accepted Solutions
vincent_ardiet_
Specialist
Specialist

Yes it matters because the expression generated by QS (you can see the output expression expanding the Modifier menu) is adding functions like Above which needs to include your set analysis in order not to be sensitive to  FinYear_shipping.
You can try like this (replace SERIES_FIELD and X_AXIS_FIELD with your fields):
Sum({<FinYear_shipping>}Aggr(RangeSum(Above(Sum({<FinYear_shipping>}Value),0,RowNo())),(SERIES_FIELD,(Numeric, Ascending), (Text, Ascending)),(X_AXIS_FIELD,(Numeric, Ascending), (Text, Ascending))))

View solution in original post

4 Replies
vincent_ardiet_
Specialist
Specialist

Are you using the Modifier feature of QS with your measure or you are writing your own expression to cumulate values?

 

Mini_Elaine
Contributor III
Contributor III
Author

Hi Vincent,

I am using modifier feature of QS with my measure rather than defining it by own expression. Does it matter?

And I am not sure how to do cumulative values by expression..

 

Many thanks!

Aasir
Creator III
Creator III

Try this

Aggr(Sum({<[FinYear_shipping]= >}[product_count]), FinYear_ordering, FinMonth_ordering)

vincent_ardiet_
Specialist
Specialist

Yes it matters because the expression generated by QS (you can see the output expression expanding the Modifier menu) is adding functions like Above which needs to include your set analysis in order not to be sensitive to  FinYear_shipping.
You can try like this (replace SERIES_FIELD and X_AXIS_FIELD with your fields):
Sum({<FinYear_shipping>}Aggr(RangeSum(Above(Sum({<FinYear_shipping>}Value),0,RowNo())),(SERIES_FIELD,(Numeric, Ascending), (Text, Ascending)),(X_AXIS_FIELD,(Numeric, Ascending), (Text, Ascending))))