Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
kashjaniqlik
New Contributor III

Get Selected count without a distinct

Hello

Is there a way to get a count of selected item in a listbox without the use of a distinct please?

Thanks for your help.

Kash

1 Solution

Accepted Solutions

Re: Get Selected count without a distinct

GetSelectedCount(FieldName) doesn't require the need to use DISTINCT. But I am not sure why you want to display a single count in a list box? Do you mean a text box?

5 Replies

Re: Get Selected count without a distinct

GetSelectedCount(FieldName) doesn't require the need to use DISTINCT. But I am not sure why you want to display a single count in a list box? Do you mean a text box?

mightyqlikers
Contributor III

Re: Get Selected count without a distinct

hi,

what exactly you want.

what do you mean of count of selected item in listbox.

it will always display 1 if it is unique data coming from your source data.

$@M.

antoniotiman
Honored Contributor III

Re: Get Selected count without a distinct

If You want count Item in Listbox then You can check Show Frequency in Property.

MVP
MVP

Re: Get Selected count without a distinct

May be this:

If(GetSelectedCount(Field), Count(Field))

Partner
Partner

Re: Get Selected count without a distinct

Hi,

Try this way,

17.JPG