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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Percentage in Straight Table

Hi,

I am new to QlikView and need help in achiving following:

1. I have a straight table which has 1 dimension and 2 expressions (expression1 and expression2). I need another expression which gives me the percentage based on expression1/(expression1+expression2).

Any guidance would be helpful. Thanks

1 Reply
Agis-Kalogiannis
Employee
Employee

Hi Ravi

For the third expression you can do something like

(Column(1)/(Column(1)+Column(2)) and check the Show in Percent checkbox from the number format!!!

Can you check to see if it works?