# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
New Contributor II

## Add Field on Table with Delta Calculation for Existing Field

Hi All, a novice Qlik Sense User here seeking some help please.... basically, I would like to add a calculated field within an existing table showing the delta calculation of an existing field. Is there an effective way to creating a delta column showing the difference between 2  counts of adjacent timestamps? Snapshot provided. for reference. Thanks in advance.

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary

## Re: Add Field on Table with Delta Calculation for Existing Field

Good to know that you got the answer.

Please mark the relevant post as correct.

Regards,
Kaushik
7 Replies
Highlighted
MVP & Luminary

## Re: Add Field on Table with Delta Calculation for Existing Field

Hi Try below expression.

Count(Value) - Above(Count(Value))

Regards,
Kaushik
Highlighted
New Contributor II

## Re: Add Field on Table with Delta Calculation for Existing Field

Hi Kaushik,

I'm getting "Invalid function: Above".

Thanks.

Highlighted
MVP & Luminary

## Re: Add Field on Table with Delta Calculation for Existing Field

Which chart type are you using?

Regards,
Kaushik
Highlighted
New Contributor II

## Re: Add Field on Table with Delta Calculation for Existing Field

Hi, I 'm trying to working it out under the "Data" tab (not "Analysis"), hence, no charts involved at this point. Thanks.

Highlighted
MVP & Luminary

## Re: Add Field on Table with Delta Calculation for Existing Field

In that case you should use Previous instead of Above.

Regards,
Kaushik
Highlighted
New Contributor II

## Re: Add Field on Table with Delta Calculation for Existing Field

I think I found the solution and I used:

Count - Above(Count)

The expression has to be done within the Table under "Analysis" tab (not the Table under "Data" tab ) where I am trying to work the expression out . 😊

Many thanks for your help, Kaushik!  Much appreciated.

Highlighted
MVP & Luminary

## Re: Add Field on Table with Delta Calculation for Existing Field

Good to know that you got the answer.

Please mark the relevant post as correct.

Regards,
Kaushik