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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
laurenr171
Contributor
Contributor

Division calculation in Qlik

Hello, I have the following table of data. I need to perform the following calculation:

(VALID_LINES – EXTRA_LINES)/VALID_LINES

 

How can I tell Qlik to do this? I am thinking a custom dimension but not sure where to go from there.

CATEGORY VALID_LINES EXTRA_LINES
A 2 0
B 3 0
C 1 0
D 1 0
Labels (3)
2 Replies
BrunPierre
Partner - Master II
Partner - Master II

As below

Evaluate((VALID_LINES-EXTRA_LINES)/VALID_LINES) as [New Measure]

BrunPierre_0-1666036165590.png

MarcoWedel

If the expression you posted actually is the expression you tried to use without success then you should replace the en dash with a minus sign to get it working:

MarcoWedel_0-1666038220357.png

hope this helps

Marco