topic Re: Need help with date in QlikView

Need help with date

praveensp — Sat, 16 Nov 2024 19:37:20 GMT

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.

Re: Need help with date

sunny_talwar — Thu, 21 Nov 2019 21:09:09 GMT

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)

Re: Need help with date

praveensp — Fri, 22 Nov 2019 05:54:59 GMT

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.

Re: Need help with date

tresB — Fri, 22 Nov 2019 06:23:11 GMT

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')

Re: Need help with date

sunny_talwar — Fri, 22 Nov 2019 11:51:56 GMT

Or this

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