Make a subtraction in the same row

[ridleyyeh]

Hi All,

is any possible that can make subtraction in the same row ?

If there's any, please tell me guide me on how to do it in qliksense

Here's the screenshot

Thanks in advanced

[sergio0592]

Hi,

Try with Registered_date - Previous (Registered_date)

[DavidM]

Hi,

if you want to do this in the front end you can use the above function:

RegisteredDate - Above(RegisteredDate)

Remember to order your data by the date in the table

You can specify the offset in the function.

If you want to do this in the script, you need to use Peek and Previous - you also need to order your data here

[ridleyyeh]

Thank you guys for your quick response

As a beginner in qlik sense ,still confusing me a lot

I want to do it in creating new row and use both previous and above function but it didnt work out as expected

did i miss something ?

[DavidM]

Looks like the date is wrongly interpreted in QS - try converting the RegisterDate field to Num to check if it is right.  For example 2019-06-01 2:13:36 should be 43471.59277..