topic Re: Selecting unique records using GetSelectedCount in QlikView

Selecting unique records using GetSelectedCount

Tue, 21 Aug 2012 19:44:19 GMT

Does anyone know how I can select unique records using the GetSelectedCount. I have an if statement that is used to color code my bubbles on a chart based on the the selection and if it is 1 or multiple records. The issue is that since the records are summed as part of the chart the underlying data has multiple records so I cannot use > 1.

Using Distint with a count does not work as it does not factor in my selections and it appears that I can't use the Distint with GetSelectedCount.

Does anyone have any ideas. I pasted sample code below however the entire code is pretty long since it relates to color coding a large combination of bubles.

=if
(getselectedCount (Primary) <> 1
,

(if(Primary= 'Test',RGB(176,23,31), if(Primary= 'Test1',RGB(75,0,130), if(Primary= 'Test2',RGB(0,0,255),

)))
)
,
(if(second= 'A',RGB(176,23,31), if(second= 'B',RGB(75,0,130), if(second= 'C',RGB(0,0,255)

)))
)
)

Re: Selecting unique records using GetSelectedCount

swuehl — Tue, 21 Aug 2012 20:35:33 GMT

Not sure if I've understood. AFAIK, GetSelectedCount(FIELD) returns the number of distinct values you selected in FIELD. For example:

LOAD * INLINE [

Test

];

If you create a text object with expression

=GetSelectedCount(Test)

and a list box with field Test, then select one value out of A,B or C, you will get a GetSelectedCount of 1, each time.

So there is no need for a DISTINCT in GetSelectedCount function (or I misunderstood your request).

Regards,

Stefan

Re: Selecting unique records using GetSelectedCount

Thu, 23 Aug 2012 11:58:06 GMT

Stefan,

The issue is that the based on the hirearchy of the data the field I am using to code the colors are not unique.

For example in the table below I would using the GetSelectedCount on field Test which is not unique but I am pulling in feild Test2 into the chart.

Test Test2

A 1

A 2

A 3

B 4

C 5

C 6

Not sure if this helps clarify or not.

Thanks!

Re: Selecting unique records using GetSelectedCount

swuehl — Thu, 23 Aug 2012 12:08:29 GMT

Well, I am still confused. If you select value A from Test, what do you get using GetSelectedCount( Test )? I would assume 1, not 3. Same with values B, C. So it should not matter if your values are unique or not for GetSelectedCount.

But maybe you could explain what you want to achieve with your code in more detail. You could also post a small sample app, this probably helps to understand your problem.