topic Re: Issue in using GetFieldSelections in textbox in QlikView

Issue in using GetFieldSelections in textbox

Wed, 25 Nov 2015 15:01:45 GMT

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

Re: Issue in using GetFieldSelections in textbox

settu_periasamy — Wed, 25 Nov 2015 16:22:37 GMT

Hi,

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

=Concat(Distinct Month,',')

Re: Issue in using GetFieldSelections in textbox

Wed, 25 Nov 2015 16:27:12 GMT

Thanks Settu.

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

How to acheive it?

Re: Issue in using GetFieldSelections in textbox

sunny_talwar — Wed, 25 Nov 2015 16:29:36 GMT

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'))))

Re: Issue in using GetFieldSelections in textbox

Wed, 25 Nov 2015 16:31:20 GMT

Thanks Sunny

But sorting is not working. Still it remains same

Re: Issue in using GetFieldSelections in textbox

Wed, 25 Nov 2015 16:33:24 GMT

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?

Re: Issue in using GetFieldSelections in textbox

settu_periasamy — Wed, 25 Nov 2015 16:38:44 GMT

For Sorting, Small change from sunindia‌ Suggestion. Like

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

Re: Issue in using GetFieldSelections in textbox

sunny_talwar — Wed, 25 Nov 2015 16:39:21 GMT

Yes I did forget to add that

Re: Issue in using GetFieldSelections in textbox

sunny_talwar — Wed, 25 Nov 2015 16:42:15 GMT

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