topic Re: Measures and Timestamps not being displayed correctly in QlikView

Measures and Timestamps not being displayed correctly

yagevlevi — Mon, 21 Mar 2022 15:31:53 GMT

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.

Re: Measures and Timestamps not being displayed correctly

rwunderlich — Mon, 21 Mar 2022 20:48:05 GMT

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

Re: Measures and Timestamps not being displayed correctly

yagevlevi — Wed, 23 Mar 2022 14:36:57 GMT

Thank you!

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

Re: Measures and Timestamps not being displayed correctly

rwunderlich — Wed, 23 Mar 2022 15:32:16 GMT

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

Re: Measures and Timestamps not being displayed correctly

yagevlevi — Fri, 25 Mar 2022 14:52:50 GMT

Does this help?

Re: Measures and Timestamps not being displayed correctly

rwunderlich — Fri, 25 Mar 2022 16:48:59 GMT

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

-Rob