Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
A simple format might do what you want:
=Num( YourCurrentExpression ,'0%')
Try changing # with 0
How do you get to -6% by calculating 200/400 -1 ?
A simple format might do what you want:
=Num( YourCurrentExpression ,'0%')
That was a typo, in my original post, while copying from FINAL to RESULT table.
Hi Stephan, that works for case 1 (left side text boxes) but doesn't work for case 2 (right side text boxes).
Can you post the exact expression behind the bottom right box?
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.
Try changing # with 0
= num ( (465/522-1), '#.%' )
This trick solved my issue. I needed a decimal before %.
Both Stephan and Lorenzo's solution does work, including mine. Is there a way to award multiple answers as correct?