Hide YTD values in listbox

[#1]

Hi All,

I have a list box with values jan_15 and feb _15 , but I also have values like jan_15_YTD and feb_15_YTD .so  for the listbox I don't need any YTD values , so how do I hide YTD values?

To add to it , I need YTD values in calculations but for user to click on values in list box I need just regular months not with 'YTD' values .

[Mahamed_Qlik]

Dear Aditya,

Follow the steps below:

-Right click on Listbox

-Select properties

-Select general tab

-Select Field drop down and select Expression

- Write the Expression as   =TextBetween(ListboxFieldName,'','_YTD' )

-Click OK

-Give the tile to the field as per your requirment.

Hope is helps.

Regards,

Faizan

[Mahamed_Qlik]

Or if you want to completely remove the values in listbox which are in format of _YTD then follow the below steps:

-Right click on Listbox

-Select properties

-Select general tab

-Select Field drop down and select Expression

- Write the Expression as   ==if(Listboxfield=SubField(Listboxfield,'_YTD'),Listboxfield)

-Click OK

-Give the tile to the field as per your requirement.

Regards,

Mahamed

[sasikanth]

HI

Try this in list box expression

If(not wildmatch(YTD_FiedName,*YTD),YTD_FiedName)

Or

Aggr(only({<YTD_FiedName={'*'}-{'*YTD}>}YTD_FiedName),YTD_FiedName)

[Mahamed_Qlik]

Hi Sunny,

Did you try this .... =if(Listboxfield=SubField(Listboxfield,'_YTD'),Listboxfield)

[#6]

wildmatch function worked thanq , and thanks all for replying me

[sasikanth]

Glad it worked for you