Qlikview creates a list of unique values on each load, so for Qlikview Date from Calendar1 and Calendar2 are one list of values.
Add a dummy field as below in bold
tempDate AS Date,
tempDate AS DateToRefer,
week(tempDate) As week,
Year(tempDate) As year,
Month(tempDate) As month,
MonthName(tempDate) as monthYear,
Day(tempDate) As day,
ApplyMap('QuartersMap', month(tempDate), Null()) as quarter
//Week(weekstart(tempDate)) & '-' & WeekYear(tempDate) as weekYear,
Order By tempDate ASC;
Drop Table TempCalendar1;
TempDate AS Date,
week(TempDate) As Week,
Year(TempDate) As Year,
Month(TempDate) As Month,
MonthName(TempDate) as MonthYear,
Day(TempDate) As Day,
ApplyMap('QuartersMap', month(TempDate), Null()) as Quarter,
Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,
WeekDay(TempDate) as WeekDay
Order By TempDate ASC;
Drop Table TempCalendar;
hello, thank you for your answer, i explain you what i want.
i inform you that field Date of calendar1 is renamed Date and Date of calendar2 is renamed date
i want that i select one value in field date, i can see in field Date the values which inferior to value selected in field date.
date 2/10/2010,3//10/2010,4/10/2010 ;
when i selected 4/10/2010 in date; in Date, the possible value are 2/10/2010,3//10/2010
Please see your original script.
Calendar1: tempDate AS Date,
and Calendar2: TempDate AS Date,
Both your tables are now linked by the Date field. If you want to disconnect these please rename the field
let me understand your requirement better .
If you select 15 June 2016 , then should all dates prior to 15 June appear as possible values or only dates
from 1 June 2016 to 14 June 2016?
what exactly are you trying to achieve with this, can you share a sample of what you are trying to build?