Avoid repeatation in formula

shamsu_mk — Thu, 28 Feb 2019 06:31:43 GMT

Dear team

Below I have mentioned a formula where I am dividing one formula with another formula. There is one condition is MonthNMum-='01'. Can we change the formula where I will use MonthNum only one time

=(Sum({<[Exec P&L Heading] = {'Gross Profit'},MonthNum={'01'} ,Year ={$(=max(Year))}>}Amount)*-1)

(Sum({<[Exec P&L Heading] = {'Revenue'},MonthNum={'01'} ,Year ={$(=max(Year))}>}Amount)*-1)

I need formula something similar to mentioned below.

MonthNum='01" then (Sum({<[Exec P&L Heading] = {'Gross Profit'},Year ={$(=max(Year))}>}Amount)*-1)

(Sum({<[Exec P&L Heading] = {'Revenue'},Year ={$(=max(Year))}>}Amount)*-1)

SHamsu

Re: Avoid repeatation in formula

jfkinspari — Thu, 28 Feb 2019 08:40:24 GMT

You could explore the use of calling the formel as a function using a parameter, where the parameter is the MonthNumber. That way you only need to set the MonthNumber once when calling the function.

topic Re: Avoid repeatation in formula in QlikView

Avoid repeatation in formula

Re: Avoid repeatation in formula