Qlikview in Listbox diable some of its member

[fatihtomruk]

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.

[sunny_talwar]

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

[Chanty4u]

can u explain more?

There is option in properties

hide excluded   u can chk that option

or else

[fatihtomruk]

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?

[tresesco · Accepted solution]

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)

[settu_periasamy]

Hi,

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

=if(Month<=6,Month)

[fatihtomruk]

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‌