Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

GetSelectedField Function

Hi Everbody

I have a question about GetSelectedField and GetSelectedCount funtions , I m using an expression like this ;

if(GetSelectedCount(Ay)>0,'Report'&GetFieldSelections(Ay)&' Months')&

if(GetSelectedCount(Gün)>0,', '&GetFieldSelections(Gün)&' of days')

But as in the attach , ı cant sort days , and ı want to see all of day. Exc(1,2,3,4,5,6,7,8,9,10,11..)

Can anyone help me ?

Thanks

1 Solution

Accepted Solutions
sunny_talwar
Not applicable

Re: GetSelectedField Function

Try this:

if(GetSelectedCount(Ay)>0,'Report'&GetFieldSelections(Ay, ',', 100)&' Months')&

if(GetSelectedCount(Gün)>0,', '&GetFieldSelections(Gün, ',', 100)&' of days')

7 Replies
sunny_talwar
Not applicable

Re: GetSelectedField Function

Try this:

if(GetSelectedCount(Ay)>0,'Report'&GetFieldSelections(Ay, ',', 100)&' Months')&

if(GetSelectedCount(Gün)>0,', '&GetFieldSelections(Gün, ',', 100)&' of days')

bill_markham
Not applicable

Re: GetSelectedField Function

Maybe try the concat() function and exploit its sort_weight argument.

See concat() help entry :

https://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/ChartFunctions/StringAggregationFunctio...

silviaganhao
Not applicable

Re: GetSelectedField Function

Hi Muhammed,

Try

getfieldselections ( YourField, YourDelimiter , MaxValues )


And put in MaxValues a higher number, so that all value you select can be showed.



Regards,

Sílvia

Not applicable

Re: GetSelectedField Function

Hi Sunny

Thanks for reply , its worked but whats can ı do about sorting days ?

sunny_talwar
Not applicable

Re: GetSelectedField Function

I guess in that case go with bill.markham‌'s suggestion of using Concat() instead of GetFieldSelections

Not applicable

Re: GetSelectedField Function

Thanks for reply;

What can ı do about sorting days , when I selected days in order of 4,5,6,7,8 , output view is 6,7,4,5,8.

Not applicable

Re: GetSelectedField Function

Apply the sorting calculation   in sort tab  using match function