topic Re: listbox selection in QlikView

listbox selection

Thu, 25 Jul 2013 10:34:42 GMT

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())

Re: listbox selection

swuehl — Thu, 25 Jul 2013 10:37:09 GMT

Try

=aggr(

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

"[DimCustomer].CustomerName")

)

edit: removed misplaced equal sign

Re: listbox selection

Thu, 25 Jul 2013 10:39:43 GMT

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.

Re: listbox selection

Thu, 25 Jul 2013 10:50:34 GMT

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

Re: listbox selection

swuehl — Thu, 25 Jul 2013 11:00:24 GMT

Try

=aggr(

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

"[DimCustomer].CustomerName")

)

Re: listbox selection

Thu, 25 Jul 2013 11:02:36 GMT

Oh your good!

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