Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Now accepting applications for the Qlik Luminary and Partner Ambassador Programs: Apply by July 6!
cancel
Showing results for 
Search instead for 
Did you mean: 
newqlik2017
Creator II
Creator II

Round a decimal negative number

Capture3.PNG

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?

Labels (1)
11 Replies
vishsaggi
Champion III
Champion III

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

newqlik2017
Creator II
Creator II
Author