Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

balrammahato204
New Contributor III

List Box Issue

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.

Tags (1)
3 Replies
stigchel
Honored Contributor

Re: List Box Issue

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

=if(Year=2015,Month)

Re: List Box Issue

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.


talk is cheap, supply exceeds demand

Re: List Box Issue

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

Community Browser