Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
ipsitafujitsu
New 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