topic Re: Getselectedcount in multiple fields in QlikView

Getselectedcount in multiple fields

Mon, 20 Jul 2015 15:05:37 GMT

Hi,

could anybody give me an advice about how to use getselectedcount function for more fields? I have several dimensions started by Row.* and I would like to show expression only if there is no selection made in any of dimension Row.*

Thank you.

Re: Getselectedcount in multiple fields

maxgro — Mon, 20 Jul 2015 21:35:04 GMT

if you have few Row fields

if( GetSelectedCount(Row1)+GetSelectedCount(Row2)+...+GetSelectedCount(Rown)=0,

'no selections',

'...'

)

Re: Getselectedcount in multiple fields

Wed, 22 Jul 2015 10:17:05 GMT

thank you, but the thing is...i dont want to write all the row field individually. I would like to find a solution which offer a possibility to just write Row* which cause that expression will consider all fields beginning on "Row"

Re: Getselectedcount in multiple fields

settu_periasamy — Wed, 22 Jul 2015 10:26:53 GMT

may be Try this,

if(isnull(wildmatch(GetCurrentSelections(),'Row*')), yourexpression)

if(isnull(SubField(wildmatch(GetCurrentSelections(),'Row*'),'Row'))

Re: Getselectedcount in multiple fields

Kushal_Chawda — Wed, 22 Jul 2015 10:42:58 GMT

Please see the attached

Re: Getselectedcount in multiple fields

MayilVahanan — Wed, 22 Jul 2015 11:14:27 GMT

You can try like this

If(SubStringCount(getcurrentselections (',') ,'Row') = 0, YourExpression, 0)

Re: Getselectedcount in multiple fields

Mon, 27 Jul 2015 05:33:52 GMT

Thank you very much. I have tried all the possibilities that you suggested (substringcount and wildmatch) and they all works so far.

You made my day

Re: Getselectedcount in multiple fields

Fri, 26 May 2017 16:55:17 GMT

Hi all,

I also want to find do a GetSelectedCount on multiple (many, specific) fields, but my fields do not have a consistent name. Does anyone know whether there is a way to apply to GetSelected count to multiple fields using either a set expression on the system variables such as:

sum( {< [$Table] =- {'CATEGORY_TOUCHPOINT_BY_DATE','MasterCalendar'}>} GetSelectedCount($Field) )

or maybe a GetSelectedCount on a group of fields, e.g.:

GetSelectedCount([All Non-Aggr Fields])

where [All Non-Aggr Fields] is a cycle group I set up with all the fields in it that I wish to evaluate (in this case, all the fields not in the CATEGORY_TOUCHPOINT_BY_DATE field or the MasterCalendar field)?

There are more than 50 fields I want to include, so enumerating them by hand would be super cumbersome and hard to maintain. I realize I could rename all the fields to have a consistent start, and then this solution should work, but I'd rather not rename all my nice, human readable fields just for this logic.

Thanks in advance for any help you can offer!

Re: Getselectedcount in multiple fields

RSvebeck — Sat, 27 May 2017 21:26:17 GMT

Do you actually want to check selections in 50 particular fields, or are you looking for a solution where there is a selection in "any" field?

Re: Getselectedcount in multiple fields

Tue, 30 May 2017 12:00:03 GMT

Hi Robert - Thanks for replying!

I was trying to figure out whether there were selections in any of the fields in three of my five tables (but I didn't care about selections in the other two tables).

I ended up with a different approach using the GetCurrentSelections wildmatched against the fields in those three tables: Re: Expression dependent on which tables fields' are filtered