Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
yagevlevi
Contributor
Contributor

Measures and Timestamps not being displayed correctly

Qlik sum function won't sum an int column that is clearly a numeric value. Tried casting in all sorts of ways and it doesn't help the issues.
 
A custom measure that is calculated and working correctly is not being displayed over time using a timetsamp variable that is clearly correct and a timestamp. Line chart acting very weird.
 
support8.pngsupport6.pngsupport5.pngScreenshot 2022-03-21 113018.pngsupport4.pngsupport3.pngsupport2.pngsupport1.png
 
Labels (3)
5 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Your STORYPOINTS values appear to be strings, based on the fact that they are left justified in the list.  You can convert to numeric using Num#.

Sum(Num#(STORYPOINTS, '0.0'))

It would be best to apply the Num# in the script if possible. 

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

yagevlevi
Contributor
Contributor
Author

Thank you!

 

Any idea why my custom measures aren't displaying over time using a Timestamp variable?

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Can you verify that your Timestamp field is numeric? Put it in a listbox and see if it's right or left justified. 

yagevlevi
Contributor
Contributor
Author

Does this help?

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

They look numeric.  I'm not sure what the issue is. 

-Rob