SET ANALYSIS

yadav_anil782 · ‎2015-09-28

Dear Community ,

i want two expression with set analysis -

1- sum of "amount" column with " condition is "account_code" = 4332

2- sum of "amount" with condition is "account_code" = 3301,3302,3303,3304. plz revert so can get the correct value

qlikmsg4u · ‎2015-09-28

=Sum({<account_code = {"4332"}>}amount)

=Sum({<account_code = {"3301","3302","3303","3304"}>}amount)

PrashantSangle · ‎2015-09-28

Hi,

1:

sum({<account_code={"4332"}>}amount)

2:

sum({<account_code={"3301","3302","3303","3304"}>}amount)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

arulsettu · ‎2015-09-28

hi try this

1. sum({<account_code={'4332'}>}amount)

2. sum({<account_code={'3301','3302','3303','3304'}>}amount)

prma7799 · ‎2015-09-28

Please check

=sum({<account_code = {4332}>}amount)

=sum({<account_code = {3301,3302,3303,3304}>}amount)

gautik92 · ‎2015-09-28

=Sum({$<account_code={'4332'}>}amount)

=Sum({$<account_code={'3301','3302','3303','3304'}>}amount)

vikasmahajan · ‎2015-09-28

Hi,

Please find detailed set analysis syntax and examples using this document you can write your own expression.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Related Topics