Issue in using GetFieldSelections in textbox

[#1]

Hi All,

I have Year and Month in the data modal

I don't have data "Dec" month for Year 2015. But when i select all the 12 Months.

"Dec" is not highlighted in the Selection window but, when it is displayed when i show selections using

                        GetFieldSelections(Month,', ',12).

How to Overcome this??

[settu_periasamy]

Hi,

May be you can try to use Concat function.. Like

=Concat(Distinct Month,',')

[#3]

Thanks Settu.

It worked but it is not sorted like GetFieldSelections().

How to acheive it?

[sunny_talwar]

May be use this instead of GetFieldSelections:

If(Count(DISTINCT Month) > 0, Concat(DISTINCT Month, ', '))

For sorting

If(Count(DISTINCT Month) > 0, Concat(DISTINCT Month, ', ', Month(Date#(Month, 'MMM'))))

[#5]

Thanks Sunny

But sorting is not working. Still it remains same

[#6]

it looks like  december is not showing in greeen because you have the h=year of 2015 selected and there is no data available, which is basic QV functionality - you would be able to select all months inf 2015 was not selected

since your GetFieldSelections is only looking at month, it is doing the same thaing as not selecting the year from the list box, making all months available

I am not understanding  what you want to do and what you want your results to be?

[settu_periasamy · Accepted solution]

For Sorting, Small change from sunindia‌ Suggestion. Like

=Concat(DISTINCT Month, ', ', Month(Date#(Month,'MMM')))

[sunny_talwar]

Yes I did forget to add that

[sunny_talwar]

Yes, I did miss an important component which was correctly pointed out by Settu‌