topic Re: Hide YTD values in listbox in QlikView

Hide YTD values in listbox

Wed, 27 Jan 2016 11:21:31 GMT

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 .

Re: Hide YTD values in listbox

Mahamed_Qlik — Wed, 27 Jan 2016 11:48:00 GMT

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

Re: Hide YTD values in listbox

Mahamed_Qlik — Wed, 27 Jan 2016 11:55:59 GMT

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

Re: Hide YTD values in listbox

sasikanth — Wed, 27 Jan 2016 12:09:33 GMT

Try this in list box expression

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

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

Re: Hide YTD values in listbox

Mahamed_Qlik — Wed, 27 Jan 2016 12:13:57 GMT

Hi Sunny,

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

Re: Hide YTD values in listbox

Fri, 29 Jan 2016 06:18:02 GMT

wildmatch function worked thanq , and thanks all for replying me

Re: Hide YTD values in listbox

sasikanth — Fri, 29 Jan 2016 12:42:08 GMT

Glad it worked for you