Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
siddharthsoam
Partner - Creator II
Partner - Creator II

Generating the data for previous quarter and month

I have 2 filters one for quarter and other for month. I have derived quarter from month (1-3[Q1],4-6[Q2],7-9[Q3],10-12(Q4)).  I want to generate data for previous quarter and month simultaneously as values are selected in the filters. But the problem I am facing is I am  able to generate for either one of them. Here accounting period is the 'month'.

Whenever I select a quarter for ex Q2 it shows me data for Q1 but when I alter the month it shows 0 value in the measure.

I want the system to show that If I select month as 4 and 6 the previous measure should show me data quarter 1, month- 1 and 3 correspondingly.

Capture.JPG

I am using the following measure for generating previous month measure

Num(sum({$<Quaters={"$(=GetFieldSelections(Quaters)-1)"}>}[Service Revenue]),'##.0'),

1 Reply
nehapathak
Contributor II
Contributor II

I am facing the same problem .. kindly help