Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

siddharthsoam
Contributor

Want to calculate annualized revenue

Hi I want to calculate annualized revenue . My data structure is as follows:

  

Fiscal YearQuartersAccounting Period
FY17Q11
FY17Q12
FY17Q13
FY17Q24
FY17Q25
FY17Q26
FY17Q37
FY17Q38
FY17Q39
FY17Q410
FY17Q411
FY17Q412
FY18Q11
FY18Q12
FY18Q13
FY18Q24
FY18Q25
FY18Q26
FY18Q37
FY18Q38
FY18Q39
FY18Q410
FY18Q411

Expected Outut-Q1,Q2,Q3

I want to compute an expression where if my count of accounting period corresponding to a quarter <3,then all quarters before it should be displayed. So for example in the above table count of accounting period corresponding to Q4 is 2, then my output should display  Q1,Q2,Q3

4 Replies
MVP
MVP

Re: Want to calculate annualized revenue

>>So for example in the above table count of accounting period corresponding to Q4 is 2, then my output should display  Q1,Q2,Q3


But in your table, Q4 only corresponds to accounting period 9, 10, 11...

siddharthsoam
Contributor

Re: Want to calculate annualized revenue

Hi Jonathan,

Let me be elaborate..

My accounting period represents months, so accounting period 1 is April and so on.

When I am saying count of accounting period I meant count of the number of months for that quarter.

So my last quarter for FY18 has 2 months in it.

I hope I have clarified

MVP
MVP

Re: Want to calculate annualized revenue

OK, I understand that. Now

>>then my output should display  Q1,Q2,Q3


How do you want to display the Q1-Q3? Listbox, selection, text box....

Or do you mean to exclude the last Q if it's not yet complete?

siddharthsoam
Contributor

Re: Want to calculate annualized revenue

Hi Jonathan,

Exactly that, I want to generate an expression for calculating my revenue till Q3 quarter for FY18.

Community Browser