Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Partner
Partner

Y-axis duration negative values

Hi guys,

When I represent positive duration values on a bar chart, the y-axis show a reasonable range (from 0 to 17 seconds). However, when the values to represent are negative, that same chart shows a range from 0 to 1440 negative minutes.

Any idea of why this behavior? I expected a range between 0 and -17 seconds.

Thanks

image.png

The negative range:

image.png

7 Replies
Partner
Partner

Re: Y-axis duration negative values

Hi,

Make sure your expression format is "duration", but not "date"/"time". (Tested on QS Feb2019)

Duration.PNG

Hope this helps.

//Andrei

Partner
Partner

Re: Y-axis duration negative values

Thanks Andrei.

I've changed it from Auto to Duration, but I still get the same result.

image.png

Partner
Partner

Re: Y-axis duration negative values

Is it an issue that I'm substracting Intervals in the expressions? Is there any function other than Interval that I should be using?
When the result is positive, it works fine. Also, the actual values are OK, the problem in in the y-axis.
Partner
Partner

Re: Y-axis duration negative values

To check whether the issue is in data or in QS itself, do the following:

1. Create a table with exactly the same dimensions and measures

2. In measures change the formatting to NUMBER with format like #,###.#########

3. Check if you have values  Duration < -1

See example below:

Duration_2.PNG

Basically 1440 minutes in a day which is equal to 1 in Qlik (as well as in Excel), so you might need to get rid of date part, or be quite careful with subtraction two dates.

Hope this helps

//Andrei

Partner
Partner

Re: Y-axis duration negative values

Hi Andrei,

Thanks for your response. I've followed your advice and I created a table with same dimension and measure. The values I see in the table are the ones I'd like to have in the y-axis. 

image.png

I checked what you recommended and I don't have values < -1. Strange, right?

 

image.png

Partner
Partner

Re: Y-axis duration negative values

Hi,

That's strange indeed, I can't replicate the issue on my Feb2019 instance though. Just in case check if ComboChart behaves the same as Bar chart - if not use it, if so you can log a support ticket, however if they fixed this in the latest version, the only advice you would get is "to upgrade QS to the latest version"

Duration_3.PNG

 

//Andrei

Partner
Partner

Re: Y-axis duration negative values

Hi Andrei, I see what you mean. Out of curiosity I'll try it in the Feb 2019 version when I have a chance.

In the meantime, I'm using "Value labels" and hiding the y-axis. 

Thanks for following up!

Juan

 

image.png