topic set analysis and getfieldselections in QlikView

set analysis and getfieldselections

Thu, 30 Jan 2014 09:29:33 GMT

Hi,

I am using the following expression

sum({<[Budget Month] = {'$(= GetFieldSelections([Forecast Month]))'}>}Budget)

It only works if I select one value from Forecast month. If I select multiple months from foreclast month, the value is zero. I want that if no forecast month is selected, take sum of all budget months, otherwise take the sum of budget for those budget months for which I select the forecast months from listbox

Forecast month and budget months are two different month fields.

Arif

Re: set analysis and getfieldselections

Thu, 30 Jan 2014 11:46:33 GMT

Try to create this variable:

vForecastMonths

=replace(chr(39)&concat([Forecast Month],',')&chr(39),',',chr(39)&','&chr(39))

and change to this the expression:

sum({<[Budget Month] = {$(vForecastMonths)}>}Budget)

Hope this helps

Re: set analysis and getfieldselections

tresB — Thu, 30 Jan 2014 12:04:00 GMT

Try:

=Sum({<[Budget Month]={$(=Concat(Distinct chr(39)&[Forecast Month]&chr(39),','))}> }Budget)

Re: set analysis and getfieldselections

NareshGuntur — Thu, 30 Jan 2014 12:33:58 GMT

Try this

sum({<[Budget Month]={$(=GetFieldSelections([Forecast Month],',',100))}>}Budget)

100 should be atleast the number of distinct values in Forecast Month

Cheers,

Naresh

Re: set analysis and getfieldselections

jonathandienst — Thu, 30 Jan 2014 12:52:49 GMT

Have you tried: sum({<[Budget Month] = P([Forecast Month])>} Budget)

HTH

Jonathan