Qlik Community

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
js99
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.

Delta Count Table.JPG

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
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
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

7 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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

Hi Try below expression.

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

 

 

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
js99
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
MVP & Luminary

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

Which chart type are you using?

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
js99
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
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
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
js99
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
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
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post