Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

adimascio
New Contributor

Subtracting Two Fields within a sheet

I have a sheet that brings in data from two tables - both tables have an "amount" field.

Does anyone know how to subtract data on the fly while the report is rendering in the UI? This is not something that can be done when loading from the DB because you will not know which rows will be compared until the report is run.

I feel like using measures would work but I am unsure of the syntax...all example I see are aggregate functions (SUM, MIN, etc.)

Thanks

1 Reply
pradosh_thakur
Valued Contributor III

Re: Subtracting Two Fields within a sheet

how your data model look like ?

you may have to provide some sample data.