select possible date when i select another date

[#1]

hello,

I have one problem.

so i m 2 dimension calendar

Calendar1:

Load

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,

Resident TempCalendar1

Order By tempDate ASC;

Drop Table TempCalendar1;

Calendar2:

Load

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

Resident TempCalendar

Order By TempDate ASC;

Drop Table TempCalendar;

when i select date from celandar2, it select the same date to calendar1. I don't want this.

i want that  i select date from calendar2; it shows me the possible date from calendar1.

can you help me.thank you

[vinieme12]

Hi Kader,

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

Calendar1:

Load

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,

Resident TempCalendar1

Order By tempDate ASC;

Drop Table TempCalendar1;

Calendar2:

Load

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

Resident TempCalendar

Order By TempDate ASC;

Drop Table TempCalendar;

Cheers

V

[#3]

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.

example

date 2/10/2010,3//10/2010,4/10/2010 ;

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

[vinieme12]

Hi Kader,

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?

[#5]

hi pujari,

thank for your answer. i have another solution to my problem. i do to write expression below in qlik language:

if(calendar1.Date=getcurrentselection(),calendar2.Date=(calendar2.Date<calendar1.Date))

[vinieme12]

Great

[#7]

do you know how can i write in qlik synthax

if(calendar1.Date=getcurrentselection(),calendar2.Date=(calendar2.Date<calendar1.Date))

[vinieme12]

Can you post your expression for which you wish to use the list of possible dates?

[#9]

hello;thank you for your help.

i resolved this problem