Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
yadav_anil782
Creator II
Creator II

SET ANALYSIS

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 

6 Replies
qlikmsg4u
Specialist
Specialist

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

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

PrashantSangle

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.
arulsettu
Master III
Master III

hi try this

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

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

prma7799
Master III
Master III

Please check

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

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

gautik92
Specialist III
Specialist III

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

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

vikasmahajan

Hi,

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

Vikas