topic Re: Round a decimal negative number in QlikView

Round a decimal negative number

newqlik2017 — Wed, 25 Nov 2020 16:16:04 GMT

Final table is my initial output.

Result table is my final output.

Name is my dimension and rest of the columns are derived from a single expression (with set analysis). C1-C4 needs to be in $ format. Last 3 columns needs to be in %. This example is in excel. I need this in Qlikview. I got all parts covered, except the negative decimal numbers which I can't get into single digit percent, like in column (C4/C3) - 1.

Any ideas?

Re: Round a decimal negative number

swuehl — Tue, 03 Oct 2017 20:13:39 GMT

How do you get to -6% by calculating 200/400 -1 ?

Re: Round a decimal negative number

swuehl — Tue, 03 Oct 2017 20:15:49 GMT

A simple format might do what you want:

=Num( YourCurrentExpression ,'0%')

Re: Round a decimal negative number

newqlik2017 — Tue, 03 Oct 2017 20:22:46 GMT

That was a typo, in my original post, while copying from FINAL to RESULT table.

Re: Round a decimal negative number

newqlik2017 — Tue, 03 Oct 2017 20:25:09 GMT

Hi Stephan, that works for case 1 (left side text boxes) but doesn't work for case 2 (right side text boxes).

Re: Round a decimal negative number

lorenzoconforti — Tue, 03 Oct 2017 20:44:49 GMT

Can you post the exact expression behind the bottom right box?

Re: Round a decimal negative number

newqlik2017 — Tue, 03 Oct 2017 21:53:46 GMT

Here's the expression used =num(787 / 853 - 1, '#%') as in text box above. The result of text box 1, when applied this expression is text box 2. Ideally, I'm looking for 11% as the result.

Re: Round a decimal negative number

lorenzoconforti — Tue, 03 Oct 2017 21:56:50 GMT

Try changing # with 0

Re: Round a decimal negative number

newqlik2017 — Tue, 03 Oct 2017 22:22:20 GMT

= num ( (465/522-1), '#.%' )

This trick solved my issue. I needed a decimal before %.

Re: Round a decimal negative number

newqlik2017 — Tue, 03 Oct 2017 22:29:48 GMT

Both Stephan and Lorenzo's solution does work, including mine. Is there a way to award multiple answers as correct?

Re: Round a decimal negative number

vishsaggi — Wed, 04 Oct 2017 01:37:06 GMT

I doubt you can do that. However, who ever gave you first solution should be marked Correct and other solutions can be marked helpful.

Re: Round a decimal negative number

newqlik2017 — Sun, 08 Oct 2017 11:34:48 GMT

Re: Dimension label - rolling date

https://community.qlik.com/message/1358054#1358054

Can anyone help with this post please?