Exclude dimension in straight table total row

sifatnabil — Fri, 20 Oct 2017 09:01:21 GMT

Hi all,

I have a straight table with

dimension = Region

expression = aggr(rank(sum({<Date={'>=$(LTM)'},Customer=>}Revenue)),Region,Customer)

This gives me a revenue rank of a selected customer for each region. However, in the total row at the bottom, I want to show the revenue rank of the customer in total, without region taken into account. The "expression total" option returns a null value. Any ideas?

Re: Exclude dimension in straight table total row

sunny_talwar — Fri, 20 Oct 2017 12:28:16 GMT

May be try this

If(Dimensionality() = 0, Aggr(Rank(Sum({<Date={'>=$(LTM)'},Customer=>}Revenue)), Customer), Aggr(Rank(Sum({<Date={'>=$(LTM)'},Customer=>}Revenue)), Region, Customer))

topic Re: Exclude dimension in straight table total row in QlikView

Exclude dimension in straight table total row

Re: Exclude dimension in straight table total row