how we can use time series function in qlik view??
hi all ,
i have three columns (debit and credit and periods )
in BI, we can calculate begining balance debitand credit and ending balance debit and credit with use time series function in financial function ( PeriodRolling(<<Measure>>,<<Starting Period Offset>>,<<Ending period offset>>)
ToDate(<<Measure>> , <<Level>>)
now , i dont know, is there any function with the same property in qlikview ?
and if there isnot , how we do it?
for these calculation , should i installed QLIKVIEW DASHBOARD or any other software?
Re: how we can use time series function in qlik view??
No, Qlikview doesn't have those functions. What we do instead is use Rob Wunderlich's Qlikview Components library to create a master calendar and use set analysis expressions. See here for more information.