topic Expression in QlikView

Expression

Tue, 10 Feb 2015 11:36:00 GMT

Hi i want to get the sum for the selected fields only , and iam using the Below formula in the expression , which seems to be ok ,

But iam not getting any output .

Can someone tell me what change i need to do

The formula is

(if(match([Tab Description],'Erection Contract','Sales Contract','Works Contract'),sum({$<FiscalYear={$(=MAX(FiscalYear))}>}[Contract Value net])))

Re: Expression

arulsettu — Tue, 10 Feb 2015 11:41:28 GMT

try like this

sum({<[Tab Description] ={'Works Contract', 'Sales Contract','Erection Contract'},$<[Fiscal Year]={$(=Max([Fiscal Year]))},[Fiscal Period]={"<=$(=max([Fiscal Period]))"},[Fiscal Month]=>}[Contract Value net]))

Re: Expression

sunny_talwar — Tue, 10 Feb 2015 11:42:25 GMT

Maybe this will work:

=Sum({$<FiscalYear={$(=MAX(FiscalYear))}, [Tab Description] = {'Erection Contract','Sales Contract','Works Contract'}>} [Contract Value net])))

Best,

Re: Expression

rubenmarin — Tue, 10 Feb 2015 11:45:41 GMT

Hi, where are you using this expression?, it can work on a chart where [Tab Description] is a dimension or if only one value of [Tab Description] is selected, if there is no such dimension or selection maybe is returning more than one value for [Tab Description] and in expression is translated as Null().