Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
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.

Highlighted
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