Add Field on Table with Delta Calculation for Existing Field

[js99]

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.

[kaushiknsolanki]

Hi Try below expression.

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

[js99]

Hi Kaushik, 

I'm getting "Invalid function: Above".

Thanks.

[kaushiknsolanki]

Which chart type are you using?

[js99]

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

[kaushiknsolanki]

In that case you should use Previous instead of Above.

[js99]

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.

[kaushiknsolanki · Accepted solution]

Good to know that you got the answer.

Please mark the relevant post as correct.