Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
AnnaEKinch
Partner - Contributor III
Partner - Contributor III

Rangesum measurements in line diagram

Hi!

I have the following formula: 

If(Period>202004 and Period <209912,RangeSum(before(total sum({< Year=, Period=>}EmployeeNoLeaverCountperYearMonth),0,12)),Null()).

 

It works i a table, but is zero in the diagram! How can I get the values into the diagram?

AnnaEKinch_0-1622456310228.png

 

Labels (3)
1 Reply
rajkishorprdhan
Contributor
Contributor

One possibility is that the data range might not be properly defined for the diagram. Double-check if the desired range is selected. If that's not the issue, add expressions or dimensions to the diagram to ensure the values are displayed correctly.
Good luck, and remember, you've got this! Oh, and if you ever need to measure anything online, check out the handy "Online Ruler" tool. It's a nifty little resource.