Ignore a selection field but select one from the same selection field

Tue, 16 Nov 2010 19:47:47 GMT

I have a field called RLM whichis a list of names. I want to ignore it but include just one person's data on a graph. This is my current expression which obvioulsy isn't working. Any help would be appreciated. Thank you.

num(Sum({<RLM=>}),(Sum({<RLM={'Jon Gehrts'}>})),num($(eSavingsPaid) + $(eSavingsBHPaid)))

Ignore a selection field but select one from the same selection field

Tue, 16 Nov 2010 20:18:33 GMT

Hello,

I suppose you want to sum up (num($(eSavingsPaid) + $(eSavingsBHPaid)) then this should work:

=num(Sum( { $ <RLM={'Jon Gehrts'}>} num($(eSavingsPaid) + $(eSavingsBHPaid))))

Regards, Roland

topic Ignore a selection field but select one from the same selection field in QlikView

Ignore a selection field but select one from the same selection field

Ignore a selection field but select one from the same selection field