Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

joshi_qlikview
Contributor

month year getselected field issue

hi gurus,

if i select Month Year it should display month in chart lable

output:Jan,Feb,Mar...........

multiple selection display

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: month year getselected field issue

Try: purgechar(getfieldselections(Month, ', '), '-0123456789')

- Marcus

View solution in original post

4 Replies
MVP & Luminary
MVP & Luminary

Re: month year getselected field issue

Try: = getfieldselections(Month, ', ')

- Marcus

joshi_qlikview
Contributor

Re: month year getselected field issue

but if i select month year it should display first 3 letters

ex:

source:     jan-12,feb-12

output:     jan,Feb

MVP & Luminary
MVP & Luminary

Re: month year getselected field issue

Try: purgechar(getfieldselections(Month, ', '), '-0123456789')

- Marcus

View solution in original post

amit_saini
Honored Contributor III

Re: month year getselected field issue

Try this:

='Month'&chr(32)&if(GetSelectedCount(Month)>0,'- '&GetFieldSelections(Month))

Thanks,

AS