Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Expression

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

                            Y

                            Z

               B           P

                            Q

                            R

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

1 Solution

Accepted Solutions
Nicole-Smith

See the attached example.

View solution in original post

4 Replies
swuehl
MVP
MVP

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])

upaliwije
Creator II
Creator II
Author

I don't understand it pls clarify

Nicole-Smith

See the attached example.

View solution in original post

upaliwije
Creator II
Creator II
Author

Thanks