topic Re: SET ANALYSIS in QlikView

SET ANALYSIS

yadav_anil782 — Mon, 28 Sep 2015 07:09:09 GMT

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 — Mon, 28 Sep 2015 07:11:39 GMT

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

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

PrashantSangle — Mon, 28 Sep 2015 07:12:33 GMT

Hi,

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

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

Regards

arulsettu — Mon, 28 Sep 2015 07:12:45 GMT

hi try this

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

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

prma7799 — Mon, 28 Sep 2015 07:14:08 GMT

Please check

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

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

gautik92 — Mon, 28 Sep 2015 07:14:26 GMT

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

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

vikasmahajan — Mon, 28 Sep 2015 10:02:59 GMT

Hi,

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

Vikas