topic Re: Subtract Custom Expressions in QlikView

Subtract Custom Expressions

Tue, 13 Jun 2017 18:16:24 GMT

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.

Anonymous — Tue, 13 Jun 2017 18:52:34 GMT

Are they columns in a straight table?

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

Tue, 13 Jun 2017 19:07:31 GMT

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 — Tue, 13 Jun 2017 19:12:13 GMT

Can you provide an example app?

Anonymous — Tue, 13 Jun 2017 19:24:59 GMT

Try. The column names should be blue.

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

CarlosAMonroy — Tue, 13 Jun 2017 19:26:17 GMT

Hi Nicole,

Use:

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

column(1)-column(2) or

expression in column1 - expression in column2

Carlos M

Tue, 13 Jun 2017 20:43:08 GMT

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