Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER 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
atkinsow
Specialist II
Specialist II

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'

atkinsow
Specialist II
Specialist II

Can you provide an example app?

atkinsow
Specialist II
Specialist II

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!!