Discussion board where members can get started with Qlik Sense.
Hi! I'm new in Qlik Sense, I've been trying to do the following but I can't.
The date and date of cancellation is composed by YEAR-CAMPAIGN (YYYYCC)
The date of cancellation is registered on the date of the order (date) like the following
but I need to do this:
I've been trying somethin like this:
But is not working, could you please help me?
Not sure how DATE_OF_CANCELATION and DATE are related in your datamodel.
sample QVF might be helpful...
You can try this as a expression..
if(DATE_OF_CANCELATION = DATE, sum(ORDERS))
assuming both of those fields are in NUMBER format. if not use num(FIELD) as FIELD in your script.
I would have to see the data, but couldn't you create a calculated dimension with DATE OF CANCELLATION = (DATE-1)
Try this in load script:
date(date(yourdate)-1) as DATE_OF_CANCELATION
Thanks everyone for your help I've solved it with the redefinition of my data it was a better solution rather than using an expression.