Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
siddharthsoam
Partner - Creator II
Partner - Creator 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
mdmukramali
Specialist III
Specialist III

Hi,

Can you share sample data file.

siddharthsoam
Partner - Creator II
Partner - Creator II
Author

sample output.JPG