Calculated Dimension in Straight Table...

Tue, 05 Jan 2016 14:13:07 GMT

Dear QV Experts,

Based on my previous thread, i tried in the calculated dimension,

=If(Aggr(Rank(RangeSum(Sum(Sales), Sum({<CustomerName = e(CustomerName), Year>} 0))) <= vTopX, CustomerName), CustomerName)

My current year is 2014, The customers listed below doesnt have sales in the year 2014 but have in the 2013 of 88 dollars.

But in the enclosed screenshot, For the customers i am getting only null. Can you please suggest me on this.

NOTE: Though it is customer dashboard, cant able to share the qvw.

Thanks in Advance.

Sasi

topic Calculated Dimension in Straight Table... in QlikView