Fill listbox dynamically

[#1]

Hello

I'm newbie in qlikview. I'm developing a model of Suppliers Balance.

I need to create a listbox from a range dates.

I load transactions table of suppliers with refdates. in the script I have a group of variables that set the measuring ranges, eg 0-30 days, 31-60 days, 61-90 days, but these ranges may change in the script and create new, eg 0-15 days , 16 to 30 days. 30-45 days, etc.

I need to create a list box to show me those ranges and that when activated will show me the data that corresponds to that date range.

Aditional i have a variable that establish the reference date to measure data.

regards
Fernan Gonzalez

[MayilVahanan]

HI

Make a new field with that range, and use that FieldName in listbox

For ex:

Load *, if(FieldName <= 30 and FieldName >=0 , '1-30', If(FieldName <= 45, '0-45')) as FieldNameAging

from tableName;

Then Use FieldNameAging in ListBox

Hope it helps

[#3]

i can't use this in the table because my range change depending another variable.in front end of model.

if my ranges are

Range1 = 0-15 days

Range2 = 16-30 days

Range3 = 31-60 days

and my data are

supply       balance     refdate

1                 100           10/10/2012

2                  -50           01/10/2012

3                 500           16/10/2012

4                -100            31/10/2012

5                 150            16/11/2012

6                 120            20/11/2012

By default the variable that set refdate = actual date, but i can change

today is 03/12/2012

supply       balance     refdate              FieldNameAging

1                 100           10/10/2012            31-60 days

2                  -50           05/11/2012            16-30 days

3                 500           17/11/2012            16-30 days

4                -100            20/11/2012            0-15 days

5                 150            25/11/2012            0-15 days

6                 120           30/11/2012            0-15 days

but if i change the value of variable eg 30/11/2012, the ranges changes for every FieldNameAging

supply       balance     refdate              FieldNameAging

1                 100           10/10/2012            31-60 days

2                  -50           05/11/2012            16-30 days

3                 500           17/11/2012             0-15 days ******* this change

4                -100            20/11/2012            0-15 days

5                 150            25/11/2012            0-15 days

6                 120           30/11/2012            0-15 days

i think i need to calculate this field in front end.

[sujeetsingh]

Just paste a sample........much confused

[#5]

Hello,

On the left of the screen i have a calendar object, I can change the date.

depending of this variable, i calculate the field of range days for every registry.

I hope you can help me.

regards,

fernan gonzalez

[sujeetsingh]

I gone through your sample a good dashboard......!!!!!

Can you please explain the expressions--Saldo Cuenta and all??????

You should go with set analysis

[sujeetsingh]

Just explain the expression functionality i will write the code for you????