Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist
Specialist

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

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

Highlighted

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

hi try this

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

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

Highlighted
Master III
Master III

Please check

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

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

Highlighted
Specialist III
Specialist III

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

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

Highlighted
Champion
Champion

Hi,

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

Vikas