Month selection in column headers

[#1]

Hi,

We want column headers in columns as following

if in month listbox continuous months are selected, i.e Jan, Feb , Mar  then  'Jan to Mar'

otherwise if Jan and March selection then concatenation of Months as 'Jan,Mar' in column headers.

Please me if some one has done same thing in past.

Regards,

Navdeep

[jsingh71]

=GetFieldSelections(YourFieldName)

This will give you selected field name.

[_rohitgharat]

hiiii Navdeep,

                use getfieldselections(FieldName) function to get your desired result.

Regards,

Rohit

[#4]

I don't want all field names in case of continuous selection, only min and max otherwise field names.

[MayilVahanan]

Hi

If the user select May, Jul and Dec, In that case, how do you need to display in the column header?

[tamilarasu]

Try like below,

=If(GetSelectedCount(Month)=2, Concat(Getfieldselections(Month),','),

Subfield(GetFieldSelections(Month,',',12),',',1) &' To ' & Subfield(GetFieldSelections(Month,',',12),',',GetSelectedCount(Month)))

Change Month to your field name.

Or simply try this.

=If(GetSelectedCount(Month)>0, Concat(Getfieldselections(Month,',',12),','))

[#7]

all three of them May,Jul, Dec. You can just relate it to how Qlikview shows data when user make selection in Month selection.

[#8]

Hi Nagraj,

That 2 column thing was just an example, actually we can have any number of discontinuous selection, in that case you solution will give x to y. Correlate it with Qlikview data selection.

[#9]

It's not giving correct O/P.

[tamilarasu]

Can you post the incorrect output or explain what is wrong!!