Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try with Registered_date - Previous (Registered_date)
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
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 ?
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..