Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Contributor II

Generating previous data from curent automated

I am using the following expression

if(H1='Previous Completed Quarter', Sum({<Quarters={$(=Concat(Distinct Quarters-1,','))} ,[Accounting Period]={$(=Concat(Distinct [Accounting Period]-3,','))}>}[Service Rev]),

if(H1='Recent Completed Quarter',sum({$}[Service Rev]))


where h1 is the header  and quarters are fetched from accounting period as follows.

quarters accounting period

  1               1,2,3

  2               4,5,6

  3               7,8,9

Problem is data is showing correctly for quarter>1 , but for quarter 1 no data is being shown.

2 Replies
Valued Contributor III

Re: Generating previous data from curent automated


Can you share sample data file.

Contributor II

Re: Generating previous data from curent automated

sample output.JPG

Community Browser