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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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