Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Expression to Show Full Total

I am looking for an expression to show the total value associated with a particular dimension even though the other dimensions in the chart only make up part of the full value.

In my example (attached) I want the Total Value for each [Invoice Number] on every row associated with that [Invoice Number]. There are 2 types of data associated with invoices, however I only want to show 1 type in my chart, but the full value of the Invoice. I have tried to use Aggr function, and Total function, but can't get it to work.

Edit: Need to be able to make selections on the Expenses Table and still show the entire Invoice Balance.

1 Solution

Accepted Solutions
Highlighted

Re: Expression to Show Full Total

May be this

Aggr(NODISTINCT Sum({<[Expense Type], ExpenseID>}Amount), [Invoice Number])

View solution in original post

4 Replies
Highlighted

Re: Expression to Show Full Total

Try this

Aggr(NODISTINCT Sum(Amount), [Invoice Number])
Highlighted
Partner
Partner

Re: Expression to Show Full Total

Perfect, thanks.

Partner
Partner

Re: Expression to Show Full Total

Need to be able to make selections on the Expenses table and still see the Entire Invoice Total.

Highlighted

Re: Expression to Show Full Total

May be this

Aggr(NODISTINCT Sum({<[Expense Type], ExpenseID>}Amount), [Invoice Number])

View solution in original post