Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
Just paste a sample........much confused
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
I gone through your sample a good dashboard......!!!!!
Can you please explain the expressions--Saldo Cuenta and all??????
You should go with set analysis
Just explain the expression functionality i will write the code for you????