Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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?

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