listbox selection

[#1]

Hello,

How come this expression not work?

I wanna show those companies who have data in this year in my listbox

=if(sum({<Year={$(vYearToday)},"[DimCustomer].CustomerName">} "[FactQVTimeRegistered].TimeRegistered") > 0, "[DimCustomer].CustomerName", null())

[swuehl]

Try

=aggr(

if(sum({<Year={$(vYearToday)},"[DimCustomer].CustomerName">} "[FactQVTimeRegistered].TimeRegistered") > 0, "[DimCustomer].CustomerName")

,

"[DimCustomer].CustomerName")

)

edit: removed misplaced equal sign

[#3]

I also had something similar to this before - The only downside about this aggr. is that when selection a company then i will only see this company (I see companies who are faded out with grey)

Is it possible to do so, i get all companies with data, but when selecting a company the others are greyed out.

[#4]

Nope- My variable is a int, so it works fine (tested it with other expressions)

[swuehl · Accepted solution]

Try

=aggr(

if(sum({<Year={$(vYearToday)},"[DimCustomer].CustomerName">} "[FactQVTimeRegistered].TimeRegistered") > 0, only({<"[DimCustomer].CustomerName">} "[DimCustomer].CustomerName") )

,

"[DimCustomer].CustomerName")

)

[#6]

Oh your good!

Thank you Can you explain why? and what the difference is?