topic Re: GetFieldSelections returns Null() on multiple selections in QlikView

GetFieldSelections returns Null() on multiple selections

wynnjimbbt — Wed, 25 Nov 2020 16:16:04 GMT

the expression and variables below work except when making multiple selections on fields [Ref Qualified Week Ending] or field [Week Ending]. Returns null() when making multiple selections on fields [Ref Qualified Week Ending] or [Week Ending]

vGetQualfWeekEnding =

if(GetSelectedCount([Ref Qualified Week Ending])>0,Date(GetFieldSelections([Ref Qualified Week Ending]),'MM/DD/YYYY'), if(GetSelectedCount([Week Ending])>0, Date(GetFieldSelections([Week Ending]),'MM/DD/YYYY'),'*'))

Re: GetFieldSelections returns Null() on multiple selections

luismadriz — Tue, 02 Jan 2018 21:52:00 GMT

Hi Jim,

That's expected behaviour. If the count > 0 then multiple dates are used, you may need an aggregation such as Max, Min, etc. to be used on Ref Qualified Week Ending and Week Ending

Cheers,

Luis

Re: GetFieldSelections returns Null() on multiple selections

sergio0592 — Tue, 02 Jan 2018 22:02:38 GMT

So, you can apply date formating in your load statement for your two fields in order to avoid to use Date() in your expression.

Re: GetFieldSelections returns Null() on multiple selections

wynnjimbbt — Tue, 02 Jan 2018 22:09:48 GMT

so I use this same logic on three other fields and return multiple values

vGetQualfYear =

if(GetSelectedCount([Ref Qualified Year])>0,GetFieldSelections([Ref Qualified Year]),if(GetSelectedCount([Year])>0, GetFieldSelections([Year]),'*'))

vGetQualfMonth =

if(GetSelectedCount([Ref Qualified Month])>0,GetFieldSelections([Ref Qualified Month]),if(GetSelectedCount([Month])>0, GetFieldSelections([Month]),'*'))date

I do not want the max or min [Ref Qualified Week Ending] dates if we select three dates I need them all

Re: GetFieldSelections returns Null() on multiple selections

luismadriz — Tue, 02 Jan 2018 22:37:26 GMT

Ok, then you may need to format the dates on the load instead.

Re: GetFieldSelections returns Null() on multiple selections

luismadriz — Tue, 02 Jan 2018 23:00:57 GMT

Remember that getfieldselections returns a string and you may need to configure that string,. What would happen is ALL dates are selected, of ALL but one or two. How many dates do you want listed, etc.

Re: GetFieldSelections returns Null() on multiple selections

MayilVahanan — Wed, 03 Jan 2018 06:06:02 GMT

In that case, you can try like below

GetFieldSelections([Ref Qualified Week Ending], ',', 1000)

Third Parameter is nothing but you can mention Max values, for example, I mentioned 1000. And also, recommend to use date format in back end itself.

Re: GetFieldSelections returns Null() on multiple selections

pradosh_thakur — Wed, 03 Jan 2018 06:56:47 GMT

What about this

vGetQualfWeekEnding =

if(GetSelectedCount([Ref Qualified Week Ending])>0,

CONCAT(Date([Ref Qualified Week Ending],'MM/DD/YYYY'),','),

if(GetSelectedCount([Week Ending])>0, CONCAT(Date([Week Ending]),'MM/DD/YYYY'),','), '*' )

)

Re: GetFieldSelections returns Null() on multiple selections

pradosh_thakur — Wed, 03 Jan 2018 13:35:51 GMT

or this

vGetQualfWeekEnding =

if(GetSelectedCount([Ref Qualified Week Ending])>0,

CONCAT(distinct Date([Ref Qualified Week Ending],'MM/DD/YYYY'),','),

if(GetSelectedCount([Week Ending])>0, CONCAT(distinct Date([Week Ending]),'MM/DD/YYYY'),','), '*' )

)

Re: GetFieldSelections returns Null() on multiple selections

wynnjimbbt — Wed, 03 Jan 2018 14:59:22 GMT

Thanks!

This was very helpful.

=if(GetSelectedCount([Ref Qualified Week Ending])>0,
CONCAT(Distinct Date([Ref Qualified Week Ending],'MM/DD/YYYY'),','),
if(GetSelectedCount([Week Ending])>0, CONCAT(Distinct Date([Week Ending],'MM/DD/YYYY'),','),'*'))

Re: GetFieldSelections returns Null() on multiple selections

wynnjimbbt — Thu, 04 Jan 2018 23:07:39 GMT

Pradosh,

I still have trouble evaluating vGetQualfWeekEnding when 2 or more dates are selected:

ex.

=$(vGetQualfWeekEnding) returns 09/23/2017, 09/30/2017

=sum({$< LogonID ={"*"}, [Week Ending] = {'$(=$(vGetQualfWeekEnding))'} >}[Target PMP Ref] ) returns a zero; there is data

=$(ePMPRefTarget) returns "Error in set modifier ad hoc element list: ',' or ')' expected"

ePMPRefTarget:

LogonID ={"*"},[Ref Qualified Date]=, [Ref Qualified Year]=, [Ref Qualified Quarter]=, [Ref Qualified Month]=, [Ref Qualified Week Ending]=, Advisor=, [Group]=, [Region Team]=,Year = {$(=max(Year))} , Quarter = { $(=$(vGetQualfQuarter))} , Month = { $(=$(vGetQualfMonth))}, [Week Ending] = {'$(=$(vGetQualfWeekEnding))'}

Thanks in advance! Hope you can help,

Jim

Re: GetFieldSelections returns Null() on multiple selections

pradosh_thakur — Fri, 05 Jan 2018 02:34:38 GMT

=sum({$< LogonID ={"*"}, [Week Ending] = {'$(=$(vGetQualfWeekEnding))'} >}[Target PMP Ref] ) put this in a text box or in a column without any label. hover on top of that and you can see how it is being evaluated . please post the screenshot.

and try this as well and post the screenshot. it will help understand the issue better.

=sum({$< LogonID ={"*"}, [Week Ending] = {'$(vGetQualfWeekEnding)'} >}[Target PMP Ref] )