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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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)))



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