GetSelectedField Function

[#1]

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

[sunny_talwar · Accepted solution]

Try this:

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

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

[Anonymous]

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...

[Anonymous]

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

[#5]

Hi Sunny

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

[sunny_talwar]

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

[#7]

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.

[#8]

Apply the sorting calculation   in sort tab  using match function