Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
madeleine_josef
Not applicable

Set analysis

Hi,

How can I write the following expression so that I can include several account numbers?

sum({$<Account={'4645'}>}ClaimCost)

I would like the sum of account 4643, 4644, 4645, 4646, 4647, 4648 and 4649.

Thank you!

1 Solution

Accepted Solutions
rittermd
Not applicable

Re: Set analysis

Try this

sum({$<Account={'4645',"4643","4644","4646","4647","4648","4649"}>}ClaimCost)

4 Replies
robert_mika
Not applicable

Re: Set analysis

sum({$<Account={'4645','4644'.....}>}ClaimCost)


or create a variable


sum({$<Account={$(vAcc)}>}ClaimCost)



Capture.PNG





rittermd
Not applicable

Re: Set analysis

Try this

sum({$<Account={'4645',"4643","4644","4646","4647","4648","4649"}>}ClaimCost)

sunny_talwar
Not applicable

Re: Set analysis

Or even without single quotes:

Sum({$<Account={4645, 4643, 4644, 4645, 4646, 4647, 4648, 4649}>}ClaimCost)

madeleine_josef
Not applicable

Re: Set analysis

Thanks for your quick reply everyone!

It works with double quotes, single quotes and also without quotes.