Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ipsita
Partner - Contributor
Partner - Contributor

How can I achieve the deviation in days calculating from Current date.

Hi Team,

I need help to achieve the result for below formula. Can you please let me know what would be the correct expression so that i will get the result for the progress% of  my application. I have not used script loading. I have loaded my DB tables through data manager. so i need correct expression to apply to get the result.

Progress (in days) = ( Current Date  - Average RegistrationDate)

I have taken Date as in Filter visualization.

Current date would be like whatever value I am selecting from Date filter. It can be the current system date or can be any other date which I will select from Date filter.

RegistrationDate will be like follows:

RegistrationDate

 

12/1/2016
12/7/2016
12/7/2016
12/7/2016
12/7/2016
11/1/2016
12/5/2016
12/5/2016
5/9/2017
5/9/2017
11/15/2016

Any help regarding same is highly appreciated.


Thanks,

Ipsita

0 Replies