Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
praveensp
Contributor
Contributor

Need help with date

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. 

capture1.PNG

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.

 
 
Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

Or this

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

View solution in original post

4 Replies
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
Contributor
Contributor
Author

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
MVP
MVP

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

Or this

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