Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
how to create two different calendars for from and to date of a field in qlikview
Thanks,
Hima
Hi Hima,
Create a calendar twice with different field names.
Regards,
Andrey
Hi,
1. Create calendar twice with diff. name.
2. Assume From data and To date as Date. Use this date into calendar.
Eg:
Load FromDate as Date,
.......
from table;
concatenate
Load Todate as Date,
.......
from table;
Hi Andrey,
i have only one field.
and i would like to create from and to empty calendar for user section. if i create two objects if i create to date then automatically the second one also reflecting i don't want that to happen
Hi Muthukumar,
i have only one field and i would like to create from and to calendar objects so that user can select the different date ranges what ever they want.
Create two variables vStartDate = Min(DateFieldName) and vEndDate = Max(DateFieldName)
Then take Calendar object and call vStartDate as Variable and use Min(DateFieldName) under Min section and Max(DateFieldName) under Max Section
Then, Create one more object using vEndDate and then call $(vStartDate)-1 under min section and Max(DateFieldName) under max section.
Then look, I am 100% sure it won't effect if you follow me. If not, You may share the application so that we can sort it out for you the wrong which you make
Ok.
refer this app,
Hi Muthukumar,
Yes,i need calendar object like that but it should not show any date as fixed date(min date) in the start date.
Hi,
Like this?