topic Re: Multiple Month Selection in QlikView

Multiple Month Selection

stephenedberkg — Wed, 31 Dec 2014 05:46:34 GMT

If i select the multiple month i want to show the label for all selected month.

Eg:

I select the month jan, feb ,march mean i want to show that three month are selected in expression label

Re: Multiple Month Selection

anbu1984 — Wed, 31 Dec 2014 05:54:11 GMT

Set to this expr in Expression label

=GetFieldSelections(Month_field)

Re: Multiple Month Selection

PrashantSangle — Wed, 31 Dec 2014 05:57:23 GMT

Hi,

Use Concat()

Regards

Re: Multiple Month Selection

alkesh_sharma — Wed, 31 Dec 2014 05:59:33 GMT

Try This

=Concate(GetFieldSelections(Month_field),'|')

Re: Multiple Month Selection

stephenedberkg — Wed, 31 Dec 2014 06:00:10 GMT

anbu1984

i got the answer but if i am not select any of month mean i want to show the last month.

Re: Multiple Month Selection

anbu1984 — Wed, 31 Dec 2014 06:00:58 GMT

If(IsNull(GetFieldSelections(Month_field)),'Dec',GetFieldSelections(Month_field))

Re: Multiple Month Selection

stephenedberkg — Wed, 31 Dec 2014 06:07:01 GMT

aanbu1984

i want to show Max(month) only because my sales last month is November mean what can i do?

Re: Multiple Month Selection

alkesh_sharma — Wed, 31 Dec 2014 06:10:24 GMT

=IF(getfiledselectioncount(Month_field) = 0, Max(Month), Concate(GetFieldSelections(Month_field),'|'))

Re: Multiple Month Selection

anbu1984 — Wed, 31 Dec 2014 06:13:43 GMT

If(GetFieldSelections(Month_field),GetFieldSelections(Month_field),Max(Month_field))

Re: Multiple Month Selection

stephenedberkg — Wed, 31 Dec 2014 06:18:31 GMT

alkesh.sharma

It show only the selected month only not show the max(Month)

Re: Multiple Month Selection

alkesh_sharma — Wed, 31 Dec 2014 06:19:42 GMT

Try this as well.

=IF(getfiledselectioncount(Month_field) = 0, Maxstring(Month), Concate(GetFieldSelections(Month_field),'|'))

Re: Multiple Month Selection

stephenedberkg — Wed, 31 Dec 2014 06:23:48 GMT

alkesh.sharma

IT is also show same think only

Re: Multiple Month Selection

stephenedberkg — Wed, 31 Dec 2014 06:35:07 GMT

anbu1984

It is working fine but it show the month id only.

and i want two think bro

1.max(year) also

2.selected month sales

=num(Sum({$<Year={$(=Max(Year))},MonthID={$(=Max(MonthID))}>}[Total Cost]),0.00)

this is my current sales expression

Re: Multiple Month Selection

anbu1984 — Wed, 31 Dec 2014 06:38:37 GMT

=If(GetFieldSelections(Month_field),GetFieldSelections(Month_field),Max(Year) & Max(Month_field))

Re: Multiple Month Selection

stephenedberkg — Wed, 31 Dec 2014 06:59:27 GMT

anbu1984

it show the 201412 for 2014 dec selection i want to show 2014-Dec like this

Re: Multiple Month Selection

alkesh_sharma — Wed, 31 Dec 2014 07:04:33 GMT

=If(GetFieldSelections(Month_field),GetFieldSelections(Month_field),Max(Year) &'-' & MaxString(Month_field))

Re: Multiple Month Selection

stephenedberkg — Wed, 31 Dec 2014 07:08:38 GMT

alkesh.sharma

But the multiple month selection is not working

Re: Multiple Month Selection

alkesh_sharma — Wed, 31 Dec 2014 07:58:11 GMT

=IF(getfiledselectioncount(Month_field) = 0, Max(Year) & '-' & Maxstring(Month), Concate(GetFieldSelections(Year) & '- ' & MaxString(GetfieldSelection(Month)),'|'))

Don't just blindly copy paste the expression. read the expression and modify a lil to fir your needs.