Need help with date

[praveensp]

Hello Experts,

I am working on a dashboard where I need help with a date function.

I have to create a date field in Table chart, which is created by a date entered by the user to which a specific number will get added from a column of the table.

the column that gets added has few numeric values that will be added to the date entered by user. below is the formula. I am creating this field as Add Calculated Dimension. 

But when I use this expression data in the pivot table goes away completely. Could you please let me know where am I doing it wrong?

Regards.

[sunny_talwar]

What exactly is vDate? Is it a hard-coded value or is this an expression? Also, is this formatted as number or is it formatted as Date (like mm/dd/yyyy)

[praveensp]

hi vDate is a variable , which holds the value entered by user. It will be entered in a date format mm/dd/yyyy. Cumulative_LT will be having numerical values.

[tresesco]

Your variable input value should be parsed to let qlik know the date value. Try like:

=date(date#(vDate, 'MM/DD/YYYY') - CUMULATIVE_LT, 'MM/DD/YYYY')

[sunny_talwar · Accepted solution]

Or this

=Date(Date#('vDate', 'MM/DD/YYYY') - CUMULATIVE_LT, 'MM/DD/YYYY')