Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi
not sure if I understood what you need, but try this:
=aggr(concat({$<Year=, Partner=, PartnerCountry=>} Client, '|'), Client)
Hope this helps you
Fernando
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
Hi
Try like this,
=if(Count(distinct Year) = 0 ,aggr(concat({$<Year=, Partner=, PartnerCountry=>}Distinct Client, ' '), Client)
Hope it helps
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!
If you have QlikView 11 just use Alternate States. Then you can assign objects to different selection 'states'.
Am on 10 I'm afraid...