topic Re: Create Multibox with selected Fields in QlikView

Create Multibox with selected Fields

Mon, 19 Nov 2012 13:02:22 GMT

Hi everyone,

I imported a csv-file that looks like this:

ID	Client
1	a
2	a
3	a
4	b
5	c
6	d
7	e
8	e
9	e
10	f
11	g
12	g

You can assume that each ID is unique.

Now I want to create a multibox that lists all distinct Clients with at least 2 realted IDs. Clients with only one related ID should be invisible.

The result should look like this:

Client	ID
a	{1,2,3}
e	{7,8,9}
g	{11,12}

Clients b,c,d,f are omitted..

Thanks in advance.

EDIT: Is there also a way to count the amount of distinct Clients with at least 2 related IDs?

Re: Create Multibox with selected Fields

Gysbert_Wassenaar — Mon, 19 Nov 2012 13:21:48 GMT

Creating a straight table that looks like that can be done with:

calculated dimension Client: if(aggr(count(distinct ID),Client)>1,Client)

expression ID: '{' & Concat(ID,',') & '}'

Check the option Suppress When Value Is Null for dimension Client

But you can't create a multibox automatically the way you want. I also don't understand what you would want with such a multibox even if it could be created. What do you intend to select and what should that selection do?

Re: Create Multibox with selected Fields

Mon, 19 Nov 2012 14:04:04 GMT

Thanks for your fast answer,

The data comes straight from an import held in a flat csv-file. Every pageview is stored with an ID and and assigned Client. Now I want to list all clients with at least two pageviews (i.e. ID).

As I see from your reply multiboxes seem to be the wrong choice for that.