Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

dandaanilreddy
Contributor II

9 quarters

Hello Qlik Experts,

I have a quarter field in which i have 11 quarters. I want to show only 9 quarters. In my requirement the starting quarter should be 31/12/2016 that is called the actual quarter and it should project the next 8 quarters i.e till 31/03/2017. I have the below expression where i am restricting the data to take 9 quarters but instead of taking the starting quarter as 31/12/2016 its taking 30/06/2017. Can someone help me please.

= Aggr(if(Fact.date>= max(total(fact.date),9),'P' & (rowno()-3)),(Fact.date) , (NUMERIC)))

Thanks,

Anil

1 Solution

Accepted Solutions

Re: 9 quarters

What about now

= Aggr(if(Fact.date <= Min(total(fact.date),9),'P' & (rowno()-1)),(Fact.date) , (NUMERIC)))

3 Replies

Re: 9 quarters

May be this

= Aggr(if(Fact.date <= Min(total(fact.date),9),'P' & (rowno()-3)),(Fact.date) , (NUMERIC)))

dandaanilreddy
Contributor II

Re: 9 quarters

No luck brother. Now its showing 31/12/2016 as P-2 instead of P0.

Thanks,

Anil

Re: 9 quarters

What about now

= Aggr(if(Fact.date <= Min(total(fact.date),9),'P' & (rowno()-1)),(Fact.date) , (NUMERIC)))

Community Browser