topic Re: Expression simplifying in QlikView

Expression simplifying

Wed, 26 Aug 2015 10:28:15 GMT

Hi Community,

Is there any way to change the below expression in simple way

(sum({<DEST_COLUMN = {'F_1275223318_1954711793'},%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'}, RCRF_REPORT_NAME = {'REP RCR Part II. RWA BS Asset'}>} F_1275223318_1954711793)+

sum({<DEST_COLUMN = {'F_1275223318_408138104'},%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'}, RCRF_REPORT_NAME = {'REP RCR Part II. RWA BS Asset'}>}F_1275223318_408138104)+

sum({<DEST_COLUMN = {'F_1275223318_276776913'},%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'}, RCRF_REPORT_NAME = {'REP RCR Part II. RWA BS Asset'}>}F_1275223318_276776913)+

sum({<DEST_COLUMN = {'F_1275223318_92460603'},%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'}, RCRF_REPORT_NAME = {'REP RCR Part II. RWA BS Asset'}>}F_1275223318_92460603)+

sum({<DEST_COLUMN = {'F_1275223318_4129076935'},%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'}, RCRF_REPORT_NAME = {'REP RCR Part II. RWA BS Asset'}>}F_1275223318_4129076935))*REP_UNIT_FACTOR_A

Re: Expression simplifying

kaushiknsolanki — Wed, 26 Aug 2015 12:09:04 GMT

Hi,

Not sure, but you can try this.

(sum({<DEST_COLUMN = {'F_1275223318_1954711793','F_1275223318_408138104','F_1275223318_276776913','F_1275223318_92460603','F_1275223318_4129076935'},%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'}, RCRF_REPORT_NAME = {'REP RCR Part II. RWA BS Asset'}>} F_1275223318_1954711793

+F_1275223318_408138104

+F_1275223318_276776913

+F_1275223318_92460603

+F_1275223318_4129076935

)*REP_UNIT_FACTOR_A

Regards,

Kaushik Solanki

Re: Expression simplifying

marcus_sommer — Wed, 26 Aug 2015 12:46:40 GMT

It looks like that you have those fields within a crosstable in your datamodel - a change to a "normal" table could be helpful: The Crosstable Load

- Marcus

Re: Expression simplifying

Wed, 26 Aug 2015 12:49:23 GMT

values are not matching with original table

Re: Expression simplifying

kaushiknsolanki — Wed, 26 Aug 2015 12:53:04 GMT

Hi,

could you please let us know, how is your data model look like.

Regards,

Kaushik Solanki

Re: Expression simplifying

Wed, 26 Aug 2015 14:09:16 GMT

pfa

Re: Expression simplifying

Kushal_Chawda — Wed, 26 Aug 2015 14:18:15 GMT

try,

sum({<DEST_COLUMN = {'F_1275223318_1954711793','F_1275223318_408138104','F_1275223318_276776913','F_1275223318_92460603','F_1275223318_4129076935'},%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'},

RCRF_REPORT_NAME = {'REP RCR Part II. RWA BS Asset'}>} alt(F_1275223318_1954711793.0)

+alt(F_1275223318_408138104,0)

+alt(F_1275223318_276776913,0)

+alt(F_1275223318_92460603,0)

+alt(F_1275223318_4129076935,0)

)*REP_UNIT_FACTOR_A

Re: Expression simplifying

Anonymous — Wed, 26 Aug 2015 15:01:24 GMT

Hi,

I don't think that is possible summarize all "sum's" in just one "sum". But you can put the set analysys, which is common in all sum's (%Month = {'$(=$(=vCurrMonth))'}, %Year = {'$(=$(=vCurrYear))'}, RCRF_REPORT_NAME = {'REP RCR Part II. RWA BS Asset'}) in a variable, to simplify the expression.

Best Regards