Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Mayurishewale
Contributor
Contributor

YOY, QOQ change

I have a Column as QTR for quarter which includes Q1, Q2,Q3,Q4
also i have a particular column which has entry as Net Revenues, Net Operating Income, Net  Cash Flow  where these all are measures created.
and i created one filter which Has YOY, QOQ,
I want
NOW I WANT THE MEASURE WHICH GIVES me if option = YOY , and if type=Net Cash Flow then show me the value of measure net cash flow of the previous year as year selected in the filter if type=Net Operating Income then show me the value of measure Net Operating income of the previous year as year selected in the filter if type=Net Income then show me the value of measure Net Income of the previous year as year selected in the filter also if option = QOQ , and if type=Net Cash Flow then show me the value of measure net cash flow of the previous quarter as year and quarter selected in the filter if type=Net Operating Income then show me the value of measure Net Operating income of the the previous quarter as year and quarter selected in the filter if type=Net Income then show me the value of measure Net Income of the previous quarter as year and quarter selected in the filter

i used this measure but it is giving error in expression

if(GetSelectedCount(Option) > 0,
if(GetFieldSelections(Option) = 'YOY',
if(Particular = 'Net Cash Flow',
Sum({<Year={"$(=Max(Year)-1)"}>} [Net Cash Flow]),
if(Particular = 'Net Operating Income',
Sum({<Year={"$(=Max(Year)-1)"}>} [Net Operating Income]),
if(Particular = 'Net Revenues',
Sum({<Year={"$(=Max(Year)-1)"}>} [Net Revenues])
)
)
),
if(GetFieldSelections(Option) = 'QOQ',
if(Particular = 'Net Cash Flow',
Sum({<Year={"$(=Max(Year))"}, [Qtr Short]={"$(=Qtr-1)"}>} [Net Cash Flow]),
if(Particular = 'Net Operating Income',
Sum({<Year={"$(=Max(Year))"}, [Qtr Short]={"$(=Qtr-1)"}>} [Net Operating Income]),
if(Particular = 'Net Revenues',
Sum({<Year={"$(=Max(Year))"}, [Qtr Short]={"$(=Qtr-1)"}>} [Net Revenues])
)
)
)
)
)
)

any one please help me?

thank you in advance!

 

Labels (3)
0 Replies