Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Detached list box

Hi,

I'm trying to build a list box that keeps detached from selections in some specific fileds but my calculated dimension doesn't seem to work.

aggr(

if(count({$ <Year=, Partner=, PartnerCountry=>} Year)=0

,  Client), Client)

Just to give you some background, these Clients have no relation whatsoever with the fields above because nothing has been sold to them in the past, so they are in fact potential Clients. Because of that, if I select a Year or a Partner for example the list would normally show empty. However, I want the list to keep showing no matter what is selected in the fields above.

Can somebody help?

Thanks!

6 Replies
fosuzuki
Valued Contributor II

Re: Detached list box

Hi

not sure if I understood what you need, but try this:

=aggr(concat({$<Year=, Partner=, PartnerCountry=>} Client, '|'), Client)

Hope this helps you

Fernando

Not applicable

Re: Detached list box

Hi,

The calculation also needs to contain the count(distinct Year) = 0 condition. How do I integrate it in the above?

Sorry... I'm new to more complex set analysis.

Thanks

Re: Detached list box

Hi

    

     Try like this,

     =if(Count(distinct Year) = 0 ,aggr(concat({$<Year=, Partner=, PartnerCountry=>}Distinct Client, ' '), Client)

     Hope it helps

Not applicable

Re: Detached list box

Shows nothing I'm afraid...

Please see attached sample file. The 'Red' list box now has the Partners I want to see. The point is that because they are not connected to any sale, whenever I select a Year or anything related to a Partner or a sale, they will disappear. What I'm trying to achieve is first of all for the list to keep visible regardless of the selections and then to grow with the other Clients currently in 'Green' and 'Yellow' that will become with 0 Year if I make a particular selection - i.e. a specific Year during which they didn't buy anything, a Partner they were never served from, etc.

Any ideas?

Thanks in advance!

Employee
Employee

Re: Detached list box

If you have QlikView 11 just use Alternate States. Then you can assign objects to different selection 'states'.

Not applicable

Re: Detached list box

Am on 10 I'm afraid...

Community Browser