Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Not applicable

Last 5 days values in staright table with date

  How to calculate the last 5 days vNAV% values using date in straight table  

FUND_IDFUND_NAMECAPITAL_FLOW_TRANSACTION_DATEvNAV%
989Fidel28-07-20160.1
992Uniges28-07-20160
989Fidel27-07-20161.8
989Fidel26-07-20160.7
992Uniges27-07-20160
989Fidel25-07-20164.8
992Uniges26-07-20160
992Uniges25-07-20160
992Uniges24-07-20160
989Fideli24-07-2016100001
989Fidel22-07-20160
989Fidel23-07-20161.2
992Uniges23-07-20160
989Fidel21-07-20163
992Uniges22-07-20160
992Unigest21-07-20160
1 Reply

Re: Last 5 days values in staright table with date

This?

Capture.PNG

Expression:

=Only({<CAPITAL_FLOW_TRANSACTION_DATE = {"$(='>=' & Date(Max(CAPITAL_FLOW_TRANSACTION_DATE) - 5, 'DD-MM-YYYY') & '<=' & Date(Max(CAPITAL_FLOW_TRANSACTION_DATE), 'DD-MM-YYYY'))"}>} vNAV%)

Community Browser