topic Re: Qlikview in Listbox diable some of its member in QlikView

Qlikview in Listbox diable some of its member

fatihtomruk — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a trouble with listbox. I have a listbox which consists of Mounths. In my excel files, there are 12 months but I want to make disable last 6 mounth(july, august...) I dont want to select last 6 mounts. can you help me?

thanx in advance.

Re: Qlikview in Listbox diable some of its member

sunny_talwar — Tue, 29 Mar 2016 14:07:25 GMT

Is Month a dual field in your application? Can you share a sample application with your expected output?

Re: Qlikview in Listbox diable some of its member

Chanty4u — Tue, 29 Mar 2016 14:11:43 GMT

can u explain more?

There is option in properties

hide excluded u can chk that option

or else

Re: Qlikview in Listbox diable some of its member

fatihtomruk — Wed, 30 Mar 2016 04:40:55 GMT

I have attached a file. There is a "Month" listbox. Excel file has 12 months but I want to see the first 6 months. I want to disable the last 6 month or hide even. Is it possible?

Re: Qlikview in Listbox diable some of its member

tresB — Wed, 30 Mar 2016 05:15:34 GMT

Several ways could be there depending on your data and dynamicity you want in the expression. The static and logically simple one could be like:

=If(Match(MonthField, 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun'), MonthField) -// this would work even if your month values are texts

if your values are duals, you could optimize the expression may be using a comparative like:

=If( MonthField<7, MonthField)

Re: Qlikview in Listbox diable some of its member

settu_periasamy — Wed, 30 Mar 2016 05:16:26 GMT

Hi,

If your month field is dual, you can just use the below expression in the ListBox..

=if(Month<=6,Month)

Re: Qlikview in Listbox diable some of its member

fatihtomruk — Wed, 30 Mar 2016 05:36:36 GMT

my values was text, so first formula worked.

Thank you tresesco‌

Your answer is also correct but my values wasn't dual. Thank you so much settu_periasamy‌