topic Re: Set Analysis Formula in QlikView

Set Analysis Formula

anthony_kinsell — Thu, 13 Feb 2014 17:01:53 GMT

Hi,

I have the below formula as an expression:

Sum ({<FundHeading -= {'Residential Sales'}>} DevBudgetAmount)

I want to change the FundHeading to Right(FundHeading,5) but it doesn't seem as simple as :

Sum ({<IF(Right(FundHeading,5)) -= {'Sales'}>} DevBudgetAmount)

Anyone point me in the right direction?

Nicole-Smith — Thu, 13 Feb 2014 17:04:44 GMT

Something like this:

sum({<FundHeading-={'*Sales'}>}DevBudgetAmount)

MK_QSL — Thu, 13 Feb 2014 17:05:21 GMT

Try Something Below

Sum ({<FundHeading -= {'=WildMatch(FundHeading, *Residential Sales*)'}>} DevBudgetAmount)

Thu, 13 Feb 2014 17:07:17 GMT

Anthony,

Right(FundHeading, 5) is a dimension ? a valid field ?

if yes, try Sum({< $(=right(FundHeading, 5)) -= the rest of your set})

Fabrice

simondachstr — Thu, 13 Feb 2014 17:08:09 GMT

Try

Sum ({<FundHeading -= {'*Sales'}>} DevBudgetAmount)