topic Re: Month selection in column headers in QlikView

Month selection in column headers

Wed, 28 Oct 2015 09:17:16 GMT

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

Re: Month selection in column headers

jsingh71 — Wed, 28 Oct 2015 09:31:15 GMT

=GetFieldSelections(YourFieldName)

This will give you selected field name.

Re: Month selection in column headers

_rohitgharat — Wed, 28 Oct 2015 09:34:08 GMT

hiiii Navdeep,

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

Regards,

Rohit

Re: Month selection in column headers

Wed, 28 Oct 2015 09:36:36 GMT

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

Re: Month selection in column headers

MayilVahanan — Wed, 28 Oct 2015 09:38:44 GMT

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

Re: Month selection in column headers

tamilarasu — Wed, 28 Oct 2015 09:41:52 GMT

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

Re: Month selection in column headers

Wed, 28 Oct 2015 09:42:29 GMT

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

Re: Month selection in column headers

Wed, 28 Oct 2015 09:45:43 GMT

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.

Re: Month selection in column headers

Wed, 28 Oct 2015 09:52:15 GMT

It's not giving correct O/P.

Re: Month selection in column headers

tamilarasu — Wed, 28 Oct 2015 09:55:19 GMT

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

Re: Month selection in column headers

martinpohl — Wed, 28 Oct 2015 09:55:55 GMT

Take this:

=if(num(max(Month))-num(min(Month))+1=GetSelectedCount(Month),maxstring({<Num={$(=min(Num))}>}Month)&'-'&maxstring({<Num={$(=max(Num))}>}Month)

,concat(Month,','))

Add a field Num in your calendar where the monthnumber is in.

Unfortunaly the concated values of months are sorted by string, not by number,

Regards

Re: Month selection in column headers

Wed, 28 Oct 2015 10:01:56 GMT

=IF(GetSelectedCount(FieldName)>2,LEFT(GetfieldSelections(FieldName),3)&' to '&RIGHT(GetfieldSelections(FieldName),3),GetfieldSelections(FieldName))