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: 
Not applicable

Subtract Custom Expressions

Hi,


I made two custom expressions labelled YTD 2017 Sales and YTD 2016 Sales.  I'd like to know how to create a 3 expression subtracting them?


Thank you.

1 Solution

Accepted Solutions
CarlosAMonroy
Creator III
Creator III

Hi Nicole,


Use:


[YTD 2017 Sales]-[YTD 2016 Sales] or

column(1)-column(2) or

expression in column1 - expression in column2


Carlos M

View solution in original post

6 Replies
Anonymous
Not applicable
Author

Are they columns in a straight table?

If so, you can just add an expression that subtracts them using their column names.

Not applicable
Author

They are in a straight table, but when I try subtracting them, I get a blank instead of a number. 'YTD 2017 Sales'-'YTD 2016 Sales'

Anonymous
Not applicable
Author

Can you provide an example app?

Anonymous
Not applicable
Author

Try.  The column names should be blue.

=[YTD 2017 Sales]-[YTD 2016 Sales]

CarlosAMonroy
Creator III
Creator III

Hi Nicole,


Use:


[YTD 2017 Sales]-[YTD 2016 Sales] or

column(1)-column(2) or

expression in column1 - expression in column2


Carlos M

Not applicable
Author

Thanks everyone!  column(1)-column(2) worked!!