Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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)))



Labels (1)
1 Reply
Not applicable
Author

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