Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
New Contributor III

Qlikview in Listbox diable some of its member

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.

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Qlikview in Listbox diable some of its member

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)

View solution in original post

6 Replies
Highlighted

Re: Qlikview in Listbox diable some of its member

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

Highlighted
Esteemed Contributor III

Re: Qlikview in Listbox diable some of its member

can u explain more?

There is option in properties

hide excluded   u can chk that option

or else

Highlighted
New Contributor III

Re: Qlikview in Listbox diable some of its member

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?

Highlighted
MVP
MVP

Re: Qlikview in Listbox diable some of its member

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)

View solution in original post

Highlighted

Re: Qlikview in Listbox diable some of its member

Hi,

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


=if(Month<=6,Month)

Capture.JPG

Highlighted
New Contributor III

Re: Qlikview in Listbox diable some of its member

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