Discussion Board for collaboration related to QlikView App Development.
I have following qvd (qvd1)
and another qvd (qvd2)
and AS on date:
I used formula In QVD1: =if(LAST_ACCESSED <= Till_Date, SEC_ID, if(DATA_CHANGED_DATE <= Till_Date, SEC_ID,Null()))
Please note that Till_Date is a variable of As on Date.
I used formula In QVD2: =if(SEC_ID = SEC_ID_RTA AND ELEMENT_ID = ELEMENT_ID_RTA AND TRANSACTION_DATE <= Till_Date, SHARES_AVAILABLE, Null())
Actually,qvd1 check last sorted LAST_ACCESSED date is available otherwise check last sorted DATA_CHANGED_DATE date record
and then qvd1 sec_ID and ELEMENT_ID pass qvd2 and check last sorted TRANSACTION_DATE balance in the qvd2. (e.g., balance of max(TRANSACTION_DATE ) <= Till_Date )
here is the desire result.
If As on Date = 5/12/2184
Lets make it simple.
Please tell about how to map the two different dates column QVDS with same id at run time date selection in one grid.
If select the Date = 5/12/2184
check last sorted date(TRANSACTION_DATE) balance in the qvd2. (e.g., balance of max(TRANSACTION_DATE) <= selected_date)
if check last sorted date(LAST_ACCESSED) paid up capital in the qvd1. (e.g., balance of LAST_ACCESSED) < selected_date)
else check last sorted date(DATA_CHANGED_DATE) paid up capital in the qvd1. (e.g., balance of DATA_CHANGED_DATE) < selected_date)