Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

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 debit  and 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?

thanks

4 Replies
nagaiank
Valued Contributor III

Re: how we can use time series function in qlik view??

The results provided by time-series functions (ToDate, Ago, PeriodRolling) can be implemented in Qlikview using Set Analysis.

MVP & Luminary
MVP & Luminary

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.


talk is cheap, supply exceeds demand
Not applicable

Re: how we can use time series function in qlik view??

Please explain more clearly.
What do I need to implement to get results?

Not applicable

Re: how we can use time series function in qlik view??

Thank you for the guidance.

I am new in qlikview and I need a clearer guide to reach the goal.

If I create the master calender , then how can i used calender for calculation begining and ending balance?

and  is it necessary install qlikview dashboard  for get result?Because i use Qlikview Personal Edition.

If  I Success in this test , then we install QLIKVIEW server , dashboard , enterperice and... for used 100 user.

Community Browser