topic Re: Expression in QlikView

Expression

upaliwije — Tue, 31 Dec 2013 18:10:44 GMT

I have written following expression and it is working fine. Here I am computing sum of amount relating dept='BRAN' irrespective of Branch selected by the user. Now I want to calculate the amount for a Region ( A Region consists of a few Branches and a BRAN consist of a few Regions) when I select a Branch. In other words when I select a branch ' X ' from list box I want the Sum of amount of the region where a few branches including branch 'X comes under.

(Sum({<[TRN_TYPE]={'R'},DEPT={'BRAN'},BRANCH= >}[AMOUNT])

DEPT REGION BRANCH

BRAN A X

B P

Pls some one help me to modify above expression. Thanks in Advance

Re: Expression

swuehl — Tue, 31 Dec 2013 18:14:28 GMT

You can look into using implicite field value definitions, i.e. the p() function, try something like

(Sum({<[TRN_TYPE]={'R'},DEPT={'BRAN'},BRANCH=, REGION = p() >}[AMOUNT])

Re: Expression

upaliwije — Tue, 31 Dec 2013 18:17:43 GMT

I don't understand it pls clarify

Re: Re: Expression

Nicole-Smith — Tue, 31 Dec 2013 18:34:35 GMT

See the attached example.

Re: Expression

upaliwije — Tue, 31 Dec 2013 19:07:34 GMT

Thanks