topic Re: Bar Chart Expression with Distinct in QlikView

Bar Chart Expression with Distinct

shannoypaul — Tue, 13 Dec 2016 02:24:58 GMT

My bar chart are without dimensions, Hence in the expression I want to aggregate based on distinct values for a particular dimension for e.g.

Current Expression:

Sum(Tender Values)

Requirement:

I want to aggregate Tender Values based on distinct values for Tender Lines.

Re: Bar Chart Expression with Distinct

sunny_talwar — Tue, 13 Dec 2016 02:29:19 GMT

May be like this:

Sum(Aggr([Tender Values], [Tender Lines]))

Re: Bar Chart Expression with Distinct

sunny_talwar — Tue, 13 Dec 2016 02:30:17 GMT

Or you can try one of these also:

Sum(Aggr(Only([Tender Values]), [Tender Lines]))

Sum(Aggr(Avg([Tender Values]), [Tender Lines]))

Sum(Aggr(Sum(DISTINCT [Tender Values]), [Tender Lines]))

Sum(Aggr(Min([Tender Values]), [Tender Lines]))

Sum(Aggr(Max([Tender Values]), [Tender Lines]))

Re: Bar Chart Expression with Distinct

jonathandienst — Tue, 13 Dec 2016 05:28:18 GMT

If you mean that you would like to use an expression for each value of Tender Lines, then the best way is to use Tender Lines a a dimension. But assuming that there are a few, fixed values of Tender Lines, then you could use expressions of the form:

=Sum({<[Tender Lines] = {'first value'}>} [Tender Values])

=Sum({<[Tender Lines] = {'second value'}>} [Tender Values])

...