topic Re: List Box Issue in QlikView

List Box Issue

balrammahato204 — Fri, 03 Jul 2015 12:57:02 GMT

Hi All,

If some one can answer this question please help me out,

Dec-13

Jan-14

Feb-14

Mar-14

Apr-14

May-14

Jun-14

Jul-14

Aug-14

Sep-14

Oct-14

Nov-14

Dec-14

Jan-15

Feb-15

Mar-15

Apr-15

May-15

I have data like this and i want to show my data in the list box only from JAN-15 to MAY-15. How can i do this.

stigchel — Fri, 03 Jul 2015 13:00:50 GMT

Use an expression (bottom of the field list) and there use something like

=if(Year=2015,Month)

Gysbert_Wassenaar — Fri, 03 Jul 2015 13:00:56 GMT

Use an expression for the listbox: if(match(MyListboxField, 'Jan-15','Feb-15','Mar-15','Apr-15','May-15'),MyListboxField).

Another (better) solution is to create a Year field in the script, add a listbox for that field and select 2015 in it.

Kushal_Chawda — Fri, 03 Jul 2015 13:09:10 GMT

Create Year field using Year(MonthName) and use this Year filed in list box to select 2015