topic Re: Get available items in a select field (non-gray items) in QlikView

Get available items in a select field (non-gray items)

Tue, 24 Nov 2015 08:54:28 GMT

I'm trying to find a function, that would give me the available items in a select field. I can get the number of possible items (non-gray) using GetPossibleCount(fieldname), but not the actual values.

I'm not interested in the grayed out items, just the ones that I can actually select.

I'm not sure there is a way to achieve that, or is there?

Re: Get available items in a select field (non-gray items)

Mark_Little — Tue, 24 Nov 2015 09:11:06 GMT

Hi,

I may be missing what you want, as GetPossibleCount() does that.

Mark

Re: Get available items in a select field (non-gray items)

tamilarasu — Tue, 24 Nov 2015 09:15:48 GMT

Hi Matthias,

Try,

Concat([Waybill Date],',') - output will be comma separated text.

Re: Get available items in a select field (non-gray items)

Tue, 24 Nov 2015 10:04:52 GMT

Re: Get available items in a select field (non-gray items)

Tue, 24 Nov 2015 10:15:09 GMT

Hi Tamil

Awesome, that is excatly what I was looking for. I needed to add a distinct to only get every value once, but this works:

=Concat(Distinct FieldName,',')

I get: Completed,Maintenance,Scheduled

Thank you very much.

@Mark, Ramanjaneyulu

Thanks for your answers. I was looking for the actual values, and not the number of values. I guess my question wasn't very precise.