topic month year getselected field issue in QlikView

month year getselected field issue

Anonymous — Wed, 29 Apr 2015 10:07:42 GMT

hi gurus,

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

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

multiple selection display

marcus_sommer — Wed, 29 Apr 2015 10:10:32 GMT

Try: = getfieldselections(Month, ', ')

- Marcus

Anonymous — Wed, 29 Apr 2015 10:13:32 GMT

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

ex:

source: jan-12,feb-12

output: jan,Feb

marcus_sommer — Wed, 29 Apr 2015 10:19:53 GMT

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

- Marcus

amit_saini — Wed, 29 Apr 2015 10:38:51 GMT

Try this:

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

Thanks,