Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Fill listbox dynamically

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

6 Replies
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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

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
Master III
Master III

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

Not applicable
Author

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
Master III
Master III

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
Master III
Master III

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